Michelle, Try the following:
<table> <tr><td>First Name</td><td>Last Name</td><td>Starship</td></tr> <cfoutput query="member"> <tr><td>#fname#</td><td>#lname#</td><td>#starship#</td></tr> </cfoutput> </table> Cheers, Rob On Tue, Feb 8, 2011 at 1:01 PM, Rick Faircloth <[email protected]>wrote: > > 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:341990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
