Re: Weekly Date Driven Content in Cold Fusion?

[tom . woiccak]

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