John, If you just want to display the first row you can do:
<cfoutput> #GetArticle.text# </cfoutput> The 4th row would require a loop with a condition looking at queryname.currentRow but if you are wanting to display the 4th row then you need to ask yourself why you are bringing back that many records in your query when you don't need them all. J.J. On 11/24/07, John Barrett <[EMAIL PROTECTED]> wrote: > Hi, > I am trying to figure out how to display only one row? > Thanks > I have a database with information about health articles, such as title, > article, date, etc. I am trying to display just the first roe, or just the > 4th row of the article filed. I can't seem to get this. > Hopefully somebody can help:) > Here is my query: > <!--- Query The Database for the articles ---> > <CFQUERY NAME="GetArticle" DATASOURCE="my_DSN"> > SELECT * > FROM my_DSN > ORDER BY article > </CFQUERY> > > <CFOUTPUT QUERY="GetArticle"> > #text# > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3158 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
