Actually what Mark Kruger said would probably work best in this situation -------- Che,
try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark -------- What he's saying is create a table called Hours with column row called hour add 23 rows (0-23) and then left join your query to that query. select * from foo, goo where foo.hour = goo.hour(+) That will return all the hours from the hour table. Not complex at all. On 8/26/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > 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:216506 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
