works well. thanks so much.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 10:07 AM
To: CF-Talk
Subject: RE: Quick Query Question...[hopefully]
There's probably a number of ways to do it. Mine may or may not be the most
efficient, but it gets the job done.
..... do your query here...query name="query" (or whatever)
<CFSET HourList = valuelist(query.hour) >
<table>
<tr>
<td>Hour</td>
<td>Order Qty</td>
</tr>
<CFLOOP FROM="0" TO="23" INDEX="hour">
<CFSET thishour = numberformat(hour,'00') >
<CFSET hit = listfind(HourList,thishour) >
<tr>
<td><cfoutput>#thishour#</cfoutput></td>
<td><CFIF hit
><cfoutput>#query.TotalOrderPerHour[hit]#</cfoutput><CFELSE>0</CFIF></td>
</tr>
</CFLOOP>
</table>
-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 9:16 AM
To: CF-Talk
Subject: RE: Quick Query Question...[hopefully]
Yeah... I could use the help. I have an idea... but its probably NOT the
best or most efficient way to do it in CF. Enlighten me, por favor!
~Che
****************************************************************************
**************
The information contained in this message, including attachments, may
contain
privileged or confidential information that is intended to be delivered only
to the
person identified above. If you are not the intended recipient, or the
person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to
anyone else.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216488
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
