- see footer for list info -<
Why are you surriounding the date with ##
In ColdFusion, this means variables, and maybe this is the problem, why not
try like this:
SELECT tblSuppliers.SupplierName, tblH_IC.ICID,
tblH_IC.YearsConsultancy, tblH_IC.NumberEmployees,
tblH_IC.ServicesStrategy, tblH_IC.ServicesBPR,
tblH_IC.ServicesFeasibility, tblH_IC.ServicesSystemProc,
tblH_IC.ServicesProjMngmnt, tblH_IC.ServicesInfoAudit,
tblH_IC.ServicesCompliance, tblH_IC.ServicesSecurity,
tblH_IC.ServicesOther, tblH_IC.Description, tblSuppliers.Address1,
tblSuppliers.Address2, tblSuppliers.Address3, tblSuppliers.Town,
tblSuppliers.Postcode, tblSuppliers.Telephone, tblSuppliers.WWW,
tblSuppliers.LastWebUpdate
FROM tblSuppliers INNER JOIN tblH_IC ON tblSuppliers.SupplierID =
tblH_IC.SupplierID
WHERE (((tblSuppliers.LastWebUpdate)>=#createODBCDate('10/15/2005')#))
ORDER BY tblSuppliers.SupplierName;
I'm using createodbcdate to pass a valid database date.
Test it and say what happened.
Cheers
----- Original Message -----
From: "Roger Broadhurst" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, March 23, 2006 10:51 AM
Subject: [CF-Dev] Date criteria ColdFusion/Access
>- see footer for list info -<
Hi all,
Probably a simple answer but it has eluded me for a couple of days.
ColdFusion MX7/Dreamweaver 8.0.1/Access 2003/Win2k.
Here is my SQL:
SELECT tblSuppliers.SupplierName, tblH_IC.ICID,
tblH_IC.YearsConsultancy, tblH_IC.NumberEmployees,
tblH_IC.ServicesStrategy, tblH_IC.ServicesBPR,
tblH_IC.ServicesFeasibility, tblH_IC.ServicesSystemProc,
tblH_IC.ServicesProjMngmnt, tblH_IC.ServicesInfoAudit,
tblH_IC.ServicesCompliance, tblH_IC.ServicesSecurity,
tblH_IC.ServicesOther, tblH_IC.Description, tblSuppliers.Address1,
tblSuppliers.Address2, tblSuppliers.Address3, tblSuppliers.Town,
tblSuppliers.Postcode, tblSuppliers.Telephone, tblSuppliers.WWW,
tblSuppliers.LastWebUpdate
FROM tblSuppliers INNER JOIN tblH_IC ON tblSuppliers.SupplierID =
tblH_IC.SupplierID
WHERE (((tblSuppliers.LastWebUpdate)>=#10/15/2005#))
ORDER BY tblSuppliers.SupplierName;
This works perfectly OK when I run the query in Access, i.e. it returns
all the records from table tblH_IC where the date criteria for the
LastWebUpdate field of tblSuppliers is met. It also works when I test
the query in the recordset dialogue box within DW. However, when I
paste the SQL into my CFM page and run it, the query seems to return
every record from tblH_IC, i.e. it ignores the date criteria in
tblSuppliers. The date criteria is 15th October 2005.
Any suggestions gratefully received.
Many thanks in advance.
Roger Broadhurst
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
