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
