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:341985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm