Interbase/Firebird SQL Error
| From: | Myke Corredera | Date: | Wed, 30 Apr 2003 23:29:56 +0000 |
| Subject: | Interbase/Firebird SQL Error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27457@lists.php.net to get a copy of this message | ||
When trying to execute a query to an Win32-Interbase server from an Win32-PHP ( Windows 2000 ) IIS machine, I get the following error
Error -- Dynamic SQL Error expression evaluation not supported
I have tested my query in common Firebird/Interbase application, when issues they work just fun but not from within Win32-PHP. Any ideas???
-- Start Query --
SELECT BF_PROJECT.NAME,
BF_BUGREPORT.SUBJECT,BF_USER.USERNAME,BF_ACTHISTORY.MODIFIEDON,
BF_ACTHISTORY.REASON
FROM BF_BUGREPORT, BF_ACTHISTORY, BF_USER, BF_PROJECT
WHERE
(BF_ACTHISTORY.ACTIONID = 'IBX0000036' or BF_ACTHISTORY.ACTIONID =
'IBX0000040') AND
(BF_ACTHISTORY.MODIFIEDON >= 'YESTERDAY'-6 ) AND
BF_BUGREPORT.STATUS IN ('IB10000003', 'IB10000004', 'IBX0000004') AND
BF_ACTHISTORY.DOC_ID = BF_BUGREPORT.ID AND
BF_USER.USERID = BF_ACTHISTORY.USERID AND
BF_PROJECT.ID = BF_BUGREPORT.PROID
ORDER BY BF_ACTHISTORY.MODIFIEDON DESCENDING
-- End Query --