I've looked at the earlier post about your db tables. you said " I then have a join table to join the two together on reservation_id & food_id."
so the reservation table has a food colum? how is that data stored? 1,3,7 (those bieng the id's for the food selection 1=Nachos, 3=Tacos, 4=Ice Cream) On 12/5/05, Kevin Fricke <[EMAIL PROTECTED]> 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/
