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/
