Brian, I coulda sworn I had an ex-QANTM tutorial up on the 'net detailing this but I'll be blowed if I can find it
instead, check out this post, esp the working CF+SQL code at the bottom (the guy must be using every datatype that MSAccess can do so you can see the context of use) - his issues had nothing to do with cfqueryparam. http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid =30364&forumid=4 one of the best things about cfqp's is that you'll never have to worry about delims again (esp if you have to slum it away from your SQLServer db's and use Access) cheers barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Thursday, 7 October 2004 1:44 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Access Date formats Barry, Most of the problem was me being an idiot. I was referring to a field name that did not exist. The where clause below works. and (((tbl_GENTracker.DateReceived) >= ###dateformat(form.sDate,'dd/mm/yyyy')###)) I could not get cpqueryparam to work. Do you have an examples of it working. Brian -----Original Message----- From: Barry Beattie [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 October 2004 12:44 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Access Date formats Brian: you might have grief with the delims: SQLServer date delims: ' Jet/MSAccess date delims: # which means > Where receivedDate > ###10/1/2004### YUCK! that's why I religiously used cfqueryparams (with no grief) you might also have issues with dd/mm/yyyy vs mm/dd/yyyy since the internal JET db engine bypasses the MSAccess settings try these formats instead. the second is more correct but the first seems to work (from memory) > Where receivedDate > #2004/1/10# or > Where receivedDate > #2004-1-10# cheers barry.b -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Thursday, 7 October 2004 11:09 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Access Date formats I'm not having much luck with it. -----Original Message----- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 October 2004 11:01 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Access Date formats I take it you can't use <cfqueryparam> ? Mark On Thu, 7 Oct 2004 10:44:58 +1000, KNOTT, Brian <[EMAIL PROTECTED]> wrote: > > > > Does anyone know the correct format for a select statement to query an > Access database based on a date > > > > i.e. > > > > Select * > > From table > > Where receivedDate > '10/1/2004' > > > > Brian > > > ------------------------------------------------------------------------ ---- ------- > This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of > its related entities ("Suncorp"). > > Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 > 11 55 or at suncorp.com.au. > > The content of this e-mail is the view of the sender or stated author and > does not necessarily reflect the view of Suncorp. The content, including > attachments, is a confidential communication between Suncorp and the > intended recipient. If you are not the intended recipient, any use, > interference with, disclosure or copying of this e-mail, including > attachments, is unauthorised and expressly prohibited. If you have received > this e-mail in error please contact the sender immediately and delete the > e-mail and any attachments from your system. > > If this e-mail constitutes a commercial message of a type that you no > longer wish to receive please reply to this e-mail by typing Unsubscribe in > the subject line. > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia Developers: > http://lists.daemon.com.au/ -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
