Rich
Because you're comparing a date field with a set of three strings
instead of with another date.
Either use CreateDate to convert your three values into a CF date
object and CreateODBCDate to convert that into an SQL one, or
use your DBMS' string/date conversion functions to create a valid date.
Nick
-----Original Message-----
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:28 PM
To: CF-Talk
Subject: Between???
I have set up a form to enter the dates which has the following query on the
form action page:
<cfquery name="get_orders" datasource="ibtoad">
SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')
</cfquery>
Why doesn't this work?
Rich
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
