That LOOKS like it should work. What is the column's datatype, and did you try #CreateODBCDate(attributes.datebox)# ?
John McKown -----Original Message----- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 8: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
