RE: [PHP-WIN] SQL query problem - SOLVED
| From: | George Pitcher | Date: | Mon, 29 Sep 2003 12:47:43 +0000 |
| Subject: | RE: [PHP-WIN] SQL query problem - SOLVED | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-21605@lists.php.net to get a copy of this message | ||
The date format in my query works fine with Access.
I solved the problem by splitting the query into two separate queries and it
now works fine.
Cheers
George
> -----Original Message-----
> From: Disko_kex [mailto:disko_kex@swedish-mushroom.com]
> Sent: 29 September 2003 1:25 pm
> To: 'George Pitcher'
> Subject: RE: [PHP-WIN] SQL query problem
>
>
> Try this: Pack.End > "'.date("Y-m-d").'"
>
> be sure that you have the same dateformat
>
>
>
>
> Hi,
>
> I'm having a problem with the following query (ODBC on M$ Access):
>
> select Pack.*, Transacts.*, Extracts.* from Pack, Transacts, Extracts
> where
> (
> Pack.End > date() and Pack.Term='Lent' and Transacts.Week=1 and
> Transacts.Pack_ID=Pack.Pack_ID and Extracts.ID=Transacts.Extract_ID)
> ORDER BY Pack.Term DESC, Transacts.Week ASC, Pack.Course_ref ASC
>
> I get a 'no records' return.
>
> Any suggestions for re-jigging the query.
>
> Cheers
>
> George in Oxford
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>