|
|
Posted by amygdala on 04/29/07 20:12
"mpar612" <mpar612@gmail.com> schreef in bericht
news:1177877211.921774.82090@h2g2000hsg.googlegroups.com...
>> (assuming you posted all relevant code)
>>
>> You create a PDO instance $dbh, use it, and then you destroy the object:
>> the next query can never be executed. Why the $dbh=null; ?
>> Either strip those out of your code, or re-instantiate a PDO object
>> before
>> using it again.
>>
>> The object will automatically be destroyed by PHP when the script ends.
>>
>> HTH
>>
>> Sh
>
> Thanks! I removed those $dbh=null; and still no luck. I know the SQL
> statements are correct. They work perfectly in the code that I wrote
> the code that uses the PEAR DB module. I have posted every bit of PHP
> code that is on the page. All of the rest is just static HTML. Any
> other thoughts? Thanks!
What happens if you do a...
try
{
$dbh->query('my query');
}
catch ( PDOException $e )
{
die( $e->getMessage() . ' on line: ' . __LINE__ );
}
....for both queries?
I suspect it could have something to do with buffered queries. I've had some
occasions where I got error messages stating that I should use:
$dbh->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE );
... because another query is not finished yet, eventhough for instance, only
one
row should be returned and I fetched that row already.
I haven't given it enough attention yet, and just set the attribute to true,
but it looks like it could be some bug.
HTH
Navigation:
[Reply to this message]
|