USE #CreateODBCDate(attributes.datebox)# ----- Original Message ----- From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 22, 2001 4:40 PM Subject: RE: Access Question
> It's doing the math. It thinks 10/18/2001 is 10 divided by 18 divided by > 2001. Use single quotes. > > > > > Bryan Love Macromedia Certified Professional > Internet Application Developer / Database Analyst > Telecommunication Systems Inc. > [EMAIL PROTECTED] > > > "What father would hesitate to say 'if there must be trouble let it be in my > day, that my child may have peace'?" > - Thomas Paine, An American Crisis > > > > -----Original Message----- > From: Greg Luce [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 5:43 PM > To: CF-Talk > Subject: Access Question > > > I haven't used access much, so I'm sure this is going to sound dumb, but > can you think of a reason that I get 0 records for this query when I can > see there's a record in the db with a date of 10/18/2001? > SELECT * > FROM messages > WHERE message_date = #attributes.datebox# > The debugging shows: > SQL = SELECT * FROM messages WHERE message_date = 10/18/2001 > > If I use single quotes around #attributes.datebox# it gives me an error > saying "datatype mismatch". > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists