Hi, John. This is definitely worth learning! You'll never want to build another static rather than dynamic website after your first, so keep at it!
I'm not sure I understand what happened when you ran the code: <cfoutput> #GetArticle.Text# </cfoutput> That should have only output one article's text. On the other hand, if you run this code: <cfoutput query="GetArticle"> #Text# </cfoutput> You'll get the text for every article, as the statement <cfoutput query="GetArticle"> loops through the entire group of records returned by the query "GetArticle". If you're just trying to always gets the first article in your database, which would be the first row, then you could set up your query like this: <cfquery name="getarticle" database"(yourdatabasename)"> select text from articles limit 1 </cfquery> Now, that works with MySQL database, which I've used for years. My table structure would be (and is when I do this): article_id article_title article_text article_byline article_author author_name author_title author_photo date_entered That gives me everything I need for a nice article display. It's not necessary to have all that; it just works well for my websites. I get the feeling that you're wanting to be able to select specific articles, rather than just the first one you entered all the time. Would that be correct? Are you wanting to get the *last* one entered or *last one updated* in the database? I do this a lot for articles which clients enter. When they enter it a timestamp gets put in the table to show it was the last one entered. If I want that article I use this query: <cfquery name="getarticle" database="articles"> select title, text from articles order by date_entered desc limit 1 </cfquery> Now, there's a lot more in that query, but let's break it down... First, this part "select title, text from articles" is just selecting the title and text from the target article. I usually use those when putting the article on a website. Next, the "order by date_entered"... "date_entered" is the row in my database table which has the timestamp for the article. The timestamp is updated automatically whenever the article is entered or updated. That way, the last article entered or updated always has the latest date. The "order by" by tell the query to return the records from the database ordered from first to last by whatever criteria I tell it to use; in this case it's "date_entered". The next little part of the query that makes this work is the "desc" part. That tells the query not only to return the records in "descending order", in this case descending order by date_entered because of the the "order by date_entered" part. And finally, the last part that makes this query return only 1 result from the query is the "limit 1" part. Now, this works I MySQL databases, but my guess is, it would probably work in Access, if that's what you're using, too. Let me know if this helps and if you need more help, tell me specifically, what database you're using, such as Access or MySQL, and how your database table is structured, meaning what columns of information you have in your database, tell me exactly what you want to accomplish with your query and display on your website, then finally, show me all the code you're using. With all that information, we can get you the results you want. I remember being exactly where you are about 10 years ago, so I know what you're going through. It can all be very confusing at first. But stick with it, it's worth it! And ColdFusion is by far the easiest way to use basic functions all the way up to the most powerful! Hope this helps! Rick > Hi William, > Thanks for your help:) This is a good help to me, as I did not even > know that was possible. > No I am trying to figure out how to display the whole article, one at > a time. > > Basically I am just trying to set up a database for lots of health > articles, and to use cfquery to call the information from the database. > > I am going to spend some time learning about this, as it is something > that I really want to learn. > > I came back to school tonight to think if the database is set up right, > a s the article text is pretty long. > > Thanks so much for your help, > John > > > > > > > ----- Original Message ---- > From: William Seiter <[EMAIL PROTECTED]> > To: CF-Newbie <[email protected]> > Sent: Saturday, November 24, 2007 8:28:16 PM > Subject: RE: cf query > > > When you say 'the first row', are you meaning the first line of text > from > each article returned? Or are you referring to all of the text from > the > first article in the result? > > If you are referring to all the text in the first result, you can do > it > the > way that JJ mentioned: > <cfoutput> > #GetArticle.text# > </cfoutput> > > > If you mean to say the first line of text from each result set, then > I > would > create a regular expression (regex) to find all of the text to the > left > of > the first sentence end. (denoted by a period, question mark, > exclamation > point) > <cfoutput QUERY="GetArticle"> > #ListFirst(text, chr(10)chr(13))# > </cfoutput> > Which will output the text on the first line, prior to the first > 'carriage > return'. > > William > -- > William E. Seiter > > Have you ever read a book that changed your life? > Go to: www.winninginthemargins.com > Enter passkey: goldengrove > > Web Developer > http://William.Seiter.com > -----Original Message----- > From: John Barrett [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 24, 2007 7:45 PM > To: CF-Newbie > Subject: cf query > > 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 involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3164 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
