27;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 (OD
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.T
