This got me what I needed:
<cfoutput>
<cfloop from="#form.startDate#" to="#form.endDate#" index="i">
<cfinvoke component="cfc.alere" method="getProductivity"
returnvariable="productivity">
<cfinvokeargument name="traxUserID" value="#session.user.TRAXUSERID#">
<cfinvokeargument name="reportDate" value="#dateformat(i,
"yyyy-mm-dd")#">
</cfinvoke>
</cfloop>
</cfoutput>
Now, all dates within the range are being returned whether there is data or not
*BIG SMILE*
Thanks for everyone's help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:3407
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
