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# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3157 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
