> On 3/18/2011 6:09 AM, Torrent Girl wrote: > > I really just need to access all of the dates in the submitted date > range. Is there a way to do this? > > Are there records in your database for all dates? Or do you want your > > SQL to make up phantom records in the result set for dates that have > no data?
I want SQL to make up phantom records in the result set for dates that have no data? I think I amy have a soluttion tho. <cfloop from="#form.startDate#" to="#form.endDate#" index="i"> <cfoutput>#dateformat(i, "yyyy-mm-dd")#<br /></cfoutput> </cfloop> I really just needed to access the date in the date range to be used in subsequent queries if the date wasn't included in the first query. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3406 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
