RE: Getting information from a cfquery/cfloop to display in a table or div

2011-02-08 Thread Rick Faircloth

Try leaving out the cfoutput/cfoutput
in the your cfloop.

Rick

-Original Message-
From: Michelle Dupray [mailto:mdup...@gmail.com] 
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=membercfoutput



#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


Re: Getting information from a cfquery/cfloop to display in a table or div

2011-02-08 Thread Rob Parkhill

Michelle,

Try the following:

table
trtdFirst Name/tdtdLast Name/tdtdStarship/td/tr

cfoutput query=member
trtd#fname#/tdtd#lname#/tdtd#starship#/td/tr
/cfoutput
/table

Cheers,

Rob

On Tue, Feb 8, 2011 at 1:01 PM, Rick Faircloth r...@whitestonemedia.comwrote:


 Try leaving out the cfoutput/cfoutput
 in the your cfloop.

 Rick

 -Original Message-
 From: Michelle Dupray [mailto:mdup...@gmail.com]
 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=membercfoutput



 #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