I could use spell check.... On 12/5/05, John Ivanoff <[EMAIL PROTECTED]> wrote: > 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/
