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:341985 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
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
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