>- see footer for list info -< Maybe in Access the #'s will be ok, but in SQL Server 2000 it's not valid. I just meant on the CF side of things.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marcos Placona Sent: 23 March 2006 11:23 To: Coldfusion Development Subject: Re: [CF-Dev] Date criteria ColdFusion/Access >- see footer for list info -< I mean, on SQL, "#" is interpreted, but on ColdFusion it's interpreted as a variable, so that's why it might not be working when he pastes the code on CF. Cheers ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: "Coldfusion Development" <[email protected]> Sent: Thursday, March 23, 2006 11:14 AM Subject: RE: [CF-Dev] Date criteria ColdFusion/Access > >- 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 _______________________________________________ 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 -<
