Try ... WHERE message_date = '#attributes.datebox#'
-----Original Message----- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 5:45 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". ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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