PEAR::db / oci8 trouble
| From: | Roko Roic | Date: | Mon, 27 May 2002 13:42:40 +0000 |
| Subject: | PEAR::db / oci8 trouble | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-6471@lists.php.net to get a copy of this message | ||
Hi,
I am trying to execute a query:
SELECT * FROM random_players WHERE status='A' AND rownum <=1 AND msisdn NOT IN (SELECT msisdn FROM user_state) AND id NOT IN (24)
I am using oracle 8 and PEAR::DB 1.2
While looking at my log file, I can see that PEAR::db tries to execute two queries where there should be only one. I am guessing this is a workaround for some compatibility issues, but it is stopping my application from working.
Why is this first query being executed and how can I prevent that?
May 27 15:16:00 [critical] DB Error: no such field ::debug:: SELECT COUNT(*) FROM random_players WHERE status='A' AND rownum <=1 AND msisdn NOT IN (SELECT msisdn FROM user_state) AND id NOT IN (24) [nativecode=ORA-00904: invalid column name]
May 27 15:16:00 [critical] DB Error: DB backend not capable ::debug:: SELECT * FROM random_players WHERE status='A' AND rownum <=1 AND msisdn NOT IN (SELECT msisdn FROM user_state) AND id NOT IN (24)
Cheers
Roko