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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
