Greg Try the following - should work.
SELECT * FROM messages WHERE message_date = #CreateODBCDate(attributes.datebox)# one word of warning this may or may not take the time into consideration, if you test this and it still does not work correctly you'll actually have to use the between keyword to check for messages between (attributes.datebox) and (attributes.datebox - 24 hours)to take account of this. Hope that makes sense. Kola > -----Original Message----- > From: Greg Luce [mailto:[EMAIL PROTECTED]] > Sent: 19 October 2001 01:45 > 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". > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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