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".
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
