ADODB problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
bimo
Forum Contributor
Posts: 100
Joined: Fri Apr 16, 2004 11:18 pm
Location: MD

ADODB problem

Post 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,
User avatar
bimo
Forum Contributor
Posts: 100
Joined: Fri Apr 16, 2004 11:18 pm
Location: MD

Post by bimo »

Sorry, I just figured out that it is working but is not returning numeric keys.
Post Reply