Re: Interbase/Firebird SQL Error
| From: | George Patterson | Date: | Thu, 01 May 2003 00:04:43 +0000 |
| Subject: | Re: Interbase/Firebird SQL Error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27458@lists.php.net to get a copy of this message | ||
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