>- see footer for list info -< Can you repeat the question? Not sure what you're asking :OD
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marcos Placona Sent: 23 March 2006 11:12 To: Coldfusion Development Subject: Re: [CF-Dev] Date criteria ColdFusion/Access >- see footer for list info -< But the same doesn't happen with CF :-) Righ Adrian? Cheers ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: "Coldfusion Development" <[email protected]> Sent: Thursday, March 23, 2006 11:08 AM Subject: RE: [CF-Dev] Date criteria ColdFusion/Access > >- 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 -< _______________________________________________ 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 -<
