Professional Web Applications Themes

need help with cfquery - Coldfusion Database Access

This should be an easy one ... unfortunately I am a n00b to sql and CF. I am trying to display a certain column in a table, the most recent one. I have a column row setup as an int value giving a new number on each submission. I want to display the highest number, but no that value itself. Basically I have a table with id and articletext, I want to display the articletext column that has the highest id number. Hope that makes sense. I know the attached code is completely wrong but I cannot figure out what ...

  1. #1

    Default need help with cfquery

    This should be an easy one ... unfortunately I am a n00b to sql and CF. I am
    trying to display a certain column in a table, the most recent one. I have a
    column row setup as an int value giving a new number on each submission. I want
    to display the highest number, but no that value itself. Basically I have a
    table with id and articletext, I want to display the articletext column that
    has the highest id number. Hope that makes sense. I know the attached code is
    completely wrong but I cannot figure out what function I need to use.

    I am trying to create a way that users can log in, create an article, and post
    it on the site, like a blog but not as advanced. This is my first big web
    programming db driven project. Thanks a lot for any help!



    <cfquery name="article" datasource="anti_sql">
    SELECT id, articletext, artcldate
    FROM articles
    HAVING id
    WHERE id=MAX(id)
    </cfquery>

    mkauspe Guest

  2. #2

    Default Re: need help with cfquery

    One way...

    <cfquery name="article" datasource="anti_sql">
    SELECT id, articletext, artcldate
    FROM articles
    WHERE id=(SELECT MAX(id) FROM articles)
    </cfquery>

    Phil
    paross1 Guest

  3. #3

    Default Re: need help with cfquery

    You're my new hero! Worked like a charm, I feel an inch less like a n00b lol

    mkauspe Guest

  4. #4

    Default Re: need help with cfquery

    Now I want to display the articles previous to that. Is there any easy way to
    create a sql statement that displays the previous ID numbers. I know I can do
    this:

    SELECT id, articletext, artcldate, artclauthor, artclname
    FROM articles
    ORDER BY id DESC

    But that creates a jumbled mess like so: [url]http://mindaugas.us/show.cfm[/url]

    I would like to be able to dsiplay one article at a time. So I need something
    like this?

    SELECT id, articletext, artcldate, artclauthor, artclname
    FROM articles
    WHERE id=(SELECT LAST(id) FROM articles)

    but sql 2k doesn't have last I think, plus that would select the last one, I
    need the second to most recent.

    Sorry for the total n00b questions this is the first time I have done anything
    with db's. I am trying to get a head start in school and for my own benefit. I
    really appreciate any help. Links to good sql tutorials are good also ;)

    mkauspe Guest

Similar Threads

  1. cfquery bug...still?
    By jlerath in forum Coldfusion Server Administration
    Replies: 2
    Last Post: November 30th, 06:06 PM
  2. CFQuery issue
    By colesc8 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: September 9th, 03:47 PM
  3. cfquery
    By ducman in forum Macromedia ColdFusion
    Replies: 3
    Last Post: August 2nd, 07:09 AM
  4. Output from Cfquery
    By mike in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 29th, 04:52 PM
  5. CFQUERY with IF THEN ELSE
    By mike2004 in forum Coldfusion Database Access
    Replies: 10
    Last Post: March 4th, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139