>- see footer for list info -< Just to elaborate(first time I've ever used that word! :OD), if you do have #10/15/2005# in your code, it'll be evaluated as 10 divided by 15 divided by 2005. Which is probably not illegal in SQL as dates can be numbers (the number of milliseconds since the birth of Christ or something) so no error is thrown.
Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marcos Placona Sent: 23 March 2006 10:56 To: Coldfusion Development Subject: Re: [CF-Dev] Date criteria ColdFusion/Access >- 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 -< _______________________________________________ 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 -<
