1) Refer to the query using array notation: <cfoutput>Title: #NewsUpdates.Title[1]# Content: #NewsUpdates.Content[1]#</cfoutput>
<cfoutput>Title: #NewsUpdates.Title[2]# Content: #NewsUpdates.Content[2]#</cfoutput> etc OR 2) If you don't know which row is which, use QoQ to select the one you need at each point in the template. On 11/30/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > 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:262187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
