Professional Web Applications Themes

Sort a Table from Query - Coldfusion - Advanced Techniques

Hi I am using a Query to display results in a Table in HTML <tr> <th>ID</th> <th>SURNAME</th> etc etc .... the query displays the results in no particular order, and not by the primary Key. the query i am using is <cfquery name="Tbl_NAMEList" datasource="db1" dbtype="ODBC" username="123" password="456"> SELECT ID,SURNAME,FORNAME, FROM TABLE_NAME </cfquery> Can some one help me with the SQL or CF to sort the table and display the details in Numerical order by the Primary Key. Thanks in Advance....

Sponsored Links
  1. #1

    Default Sort a Table from Query

    Hi

    I am using a Query to display results in a Table in HTML

    <tr>
    <th>ID</th>
    <th>SURNAME</th> etc etc ....

    the query displays the results in no particular order, and not by the primary
    Key.

    the query i am using is

    <cfquery name="Tbl_NAMEList"
    datasource="db1"
    dbtype="ODBC"
    username="123"
    password="456">

    SELECT ID,SURNAME,FORNAME,
    FROM TABLE_NAME
    </cfquery>

    Can some one help me with the SQL or CF to sort the table and display the
    details in Numerical order by the Primary Key.

    Thanks in Advance.

    Sponsored Links
    bluebirds1984 Guest

  2. #2

    Default Re: Sort a Table from Query

    add
    order by primarykeyfield

    to your query.

    Originally posted by: bluebirds1984
    Hi

    I am using a Query to display results in a Table in HTML

    <tr>
    <th>ID</th>
    <th>SURNAME</th> etc etc ....

    the query displays the results in no particular order, and not by the primary
    Key.

    the query i am using is

    <cfquery name="Tbl_NAMEList"
    datasource="db1"
    dbtype="ODBC"
    username="123"
    password="456">

    SELECT ID,SURNAME,FORNAME,
    FROM TABLE_NAME
    </cfquery>

    Can some one help me with the SQL or CF to sort the table and display the
    details in Numerical order by the Primary Key.

    Thanks in Advance.



    Dan Guest

  3. #3

    Default Re: Sort a Table from Query

    fantastic, it works perfectly
    Cheers
    bluebirds1984 Guest

Similar Threads

  1. sort tablename in sql table
    By sc in forum Coldfusion Database Access
    Replies: 4
    Last Post: September 27th, 12:52 AM
  2. Replies: 3
    Last Post: February 22nd, 10:30 AM
  3. To sort the table per fields
    By MeTin in forum Dreamweaver AppDev
    Replies: 1
    Last Post: February 20th, 05:54 PM
  4. Table sort
    By Tolgay Gül in forum ASP Database
    Replies: 2
    Last Post: September 30th, 04:02 PM
  5. Replies: 1
    Last Post: September 9th, 07:16 AM

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