Page 1 of 1

ADODB problem

Posted: Tue Nov 01, 2005 10:22 pm
by bimo
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

Code: Select all

$connection = $this->conn;
and it works when I write

Code: Select all

$fk = $connection->MetaForeignKeys($table);
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

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>");
it doesn't print anything.

Does anyone see what I'm doing wrong?

thanks,

Posted: Tue Nov 01, 2005 10:39 pm
by bimo
Sorry, I just figured out that it is working but is not returning numeric keys.