I would go so far as to run a dateformat statement on the input dates
to insure they are read correctly.
#DateFormat(Now(),"mm/dd/yyyy")#
<cfquery name="..." datasource="...">
SELECT *
FROM mytable
WHERE my_date_column >= #DateFormat(form.start_date,"mm/dd/yyyy")# and
my_date_column <= #DateFormat(form.end_date,"mm/dd/yyyy")#
</cfquery>
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 8:40 AM
Subject: Re: Weekly Date Driven Content in Cold Fusion?
>
>
> I think he actually wants something like this:
> <cfquery name="..." datasource="...">
> select * from mytable where my_date_column >= #form.start_date# and
> my_date_column <= #form.end_date#
> </cfquery>
>
>
> tom
>
>
>
> Of course!
>
> try somethig like this:
>
> <cfquery name="..." datasource="...">
> select * from mytable where start_date <= #createodbcdate(now())# and
> end_date >= #createodbcdate(now())#
> </cfquery>
>
> Alejandro Mozo Quesada
> Sistemas / Programaci
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
