Order the query to make sure the results are consistent, then use this syntax:
<cfoutput> <p>The first one: #NewsUpdates["Title"][1]#</p> <p>The second one: #NewsUpdates["Title"][2]#</p> <p>The third one: #NewsUpdates["Title"][3]#</p> </cfoutput> Adrian -----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: 30 November 2006 08:47 To: CF-Talk Subject: help on cfquery and cfoutput help on this please the code is <CFQUERY NAME="NewsUpdates" datasource="dbweb" SELECT Title,Content FROM PubContent WHERE PubcontentId BETWEEN 3703 AND 3705 </CFQUERY> the above query gives me three records.. the problem is how to display each record in three different sections of the template... is there a way to insert a parameter like pubcontentid=3703 inside the <cfoutput> creating each for every record? thanks for any help... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
