Interbase/Firebird SQL Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 --


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux