Try:
SELECT *
FROM messages
WHERE message_date = #CreateODBCDate(attributes.datebox)#
H.
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
> -----Original Message-----
> From: Greg Luce [SMTP:[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
