i guess i'm one of the "others"
heh
----- Original Message -----
From: Robert Orlini <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 12:07 PM
Subject: date range search - thanks!
> Thanks to all (Lamon, Steve, Jason, Jay, Phillip, Paul, and others) who
> helped with my "date range search" problem.
>
> Problems again with "#" sign placements and single quotes. I will read
Ben's
> info on this I promise. I don't do CF all day and going back and forth
from
> different projects makes it all the worse.
>
> Robert O. :)
>
> This code finally did it:
> <CFSET startdate = Createdate(Year,Month,Day)>
> <CFSET enddate = Createdate(Year2,Month2,Day2)>
>
> <CFQUERY name="getwweb" datasource="wwebsales">
> SELECT * FROM wwebsales
> where orderdate between #startdate# and #enddate#
> </cfquery>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
