On Wed, 30 Apr 2003 16:29:56 -0700
Myke Corredera <mcorredera@marketscan.com> wrote:
> 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 --
>
Myke,
I could be totally wrong but you seem to have a error in this section :-
BF_ACTHISTORY.MODIFIEDON >= 'YESTERDAY'-6
It doesn't seem right to be subtracting a number from a text value.
Regards
George Patterson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
