ADODB problem
Posted: Tue Nov 01, 2005 10:22 pm
I am using ADODB and it has been working very well but have run into a problem. I am creating a db connection in the constructor class. Then in the function for which I am having the problem, I access the connection like this
and it works when I write
That returns an array of all of the foreign keys.
Then I want to query the db again for each of the relational tables that the fks reference. However, It doesn't seem like the connection is working. When I write
it doesn't print anything.
Does anyone see what I'm doing wrong?
thanks,
Code: Select all
$connection = $this->conn;Code: Select all
$fk = $connection->MetaForeignKeys($table);Then I want to query the db again for each of the relational tables that the fks reference. However, It doesn't seem like the connection is working. When I write
Code: Select all
//doesn't seem to work from here on
$fval = $connection->Execute($sql);
if($fval) print("<i>fval</i>");
else print("<i>nope</i>");Does anyone see what I'm doing wrong?
thanks,