I was hoping that I wouldn't have to run multiple queries....it would take forever to run reports, etc.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jake McKee Sent: Monday, December 05, 2005 12:51 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] Grouping etc. Your approach is correct, but (without testing or coding anything at the moment) I wonder if you can, per query, only do one option output like you want. (i.e. only food and not packages) Do you have to run three separate queries? Kevin Fricke wrote: >Ok, here is a more detailed example of what I am trying to >do.......forgot to mention this part :) > > >I have a table - reservations. For each reservation, there are a >series of items that can be attached to this reservation, food, packages, options. >There is a join table that joins all of these with the reservation. > >Therefore a reservation may look like this: > >Reservation ID: 1 >Client Name: Kevin > >Food >---------- >Nachos >Tacos >Ice Cream > >Packages >---------- >Live Music >Casino > >Options >---------- >Margarita Machine >Bartender > > > >Now, I know that with group I can run the query and get all of the >reservations, group by the reservation id and then ><cfoutput>#food#</cfoutput> to lists the food options. However, I have >been unsuccessful in grouping the additional lists. It will not work properly. >That is why I was hoping that there was a way to group a list into a >query result field. I also figured that doing everything in the actual >db query would be faster.... > >Can anyone help? Or maybe this doesn't make any sense????? > >Kevin > > > >_______________________________________________ >List mailing list >Reply to DFWCFUG: >[email protected] >Subscribe/Unsubscribe: >http://lists1.safesecureweb.com/mailman/listinfo/list >List Archive: >http://lists1.safesecureweb.com/mailman/private/list >DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ > > > > > > _______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archive: http://lists1.safesecureweb.com/mailman/private/list DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ _______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archive: http://lists1.safesecureweb.com/mailman/private/list DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
