you couyld use stored procedures... On 12/5/05, Kevin Fricke <[EMAIL PROTECTED]> wrote: > 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/ >
_______________________________________________ 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/
