Les Mizzell wrote: > I always seem to get this wrong. > > For query results fields guestdetail.guest1 to guestdetail.guest10
Brad has provided the answer to your original question. So now we can point out that anytime one sees something like "query results fields guest1 to guest10", that is a huge red flag of a database design that should be normalized. The better practice would be to have a 'guest' table with a foreign key to this current table. Then there would be one record in this related table for each 'guest' associated with the main record. There are many advantages to such normalization, including that you would no longer need to concatenate your field names to loop over all the guests. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
