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/
