Try leaving out the <cfoutput></cfoutput> in the your cfloop. Rick
-----Original Message----- From: Michelle Dupray [mailto:[email protected]] Sent: Tuesday, February 08, 2011 12:24 PM To: cf-talk Subject: Getting information from a cfquery/cfloop to display in a table or div Hello, I'm trying to get information from our database to display in horizontal form (table or div). I'm able to pull information from our database with the following code. Everytime I try to incorporate a table the same information will display in on each row; different information will not display in each cell. Any ideas? <cfquery name="member" datasource="ASAGOV"> SELECT fname, lname, Starship, Rank FROM Star_Trek where rank <> 'Captain' AND rank <> 'Science Officer' </cfquery> <cfloop query="member"><cfoutput> #fname# #lname#, #starship# </cfoutput></cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
