Jason,
You need to use the CreateODBCDate function in order to use dates in SQL
queries.
>
>
> Version 1
> <CFQUERY name=3D"get_all_reference" datasource=3D"Jason_K-H_Archive">
> SELECT *
> FROM Reference
> WHERE Archive_Date BETWEEN #variables.date_A# AND #variables.date_B#
> </CFQUERY>
>
>
becomes
<CFQUERY name="get_all_reference" datasource="Jason_K-H_Archive">
SELECT *
FROM Reference
WHERE Archive_Date <= #createodbcdate(variables.date_A)# AND Archive_Date
>= #createodbcdate(variables.date_B)#
</CFQUERY>
Regards
Stephen
------------------------------------------------------------------------------
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.
