Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default SELECTING ROWS

    Hi again

    Im trying to select a particular ROW in my Database,
    I want to run a query on the 1st 2nd and 3rd rows seprately.
    the information will change and only the latest 3 will be shown.

    i know of the SELECT TOP 3* but i want to run seprate querys for the link on a
    navigation bar, but im using java, and th java coding seems to get in the way.

    <p class="leftPanelBody">
    <span class="leftPanelTitle">LATEST NEWS</span><br>
    <br>
    <cfoutput query="Links">
    <span class="leftPanelLink" onMouseUp=#JavaDo#>
    <span class="leftPanelHeader">#Date#</span><br>
    #HeadLine#<br>
    --------- <br>
    </span>
    </p>
    </cfoutput>

    Ive run a SELECT TOP 3 * query agasint the above but for some reason the style
    shet dosnt work on the the last 2.
    Obviouslt the data is beening filled out beneath the tag that give the text
    the style.
    So instead of put lost of html coding in the database.
    i need to select each row at a time, i hope this is posible if not can some
    one sujest the best course of action?

    Thanks
    Craig

    MacroDuck Guest

  2. Similar Questions and Discussions

    1. Selecting and Highlighting Multiple Rows in a DataGrid
      I am looking for an example that shows how to select and highlight multiple rows in a DataGrid. My DataGrid is part of a Web User Control which...
    2. Selecting Multiple Rows from DB
      I'm building code where I need to be able to read all the rows in a single column of data. My SQL code currently is simple and looks like this: ...
    3. Selecting rows not visible in DataGrid
      I have a need to programatically select a row in a DataGrid that may not be visible in the scroll view. If not, I would like to programatically...
    4. Datagrid: Selecting multiple rows/cols
      Hi, I would like to enhance the DataGrid by adding scripting functionality that allows the selection of multiple rows or columns via...
    5. Selecting rows in ranges
      What is the fastest way to select rows x to x in a table using db2? Following is the query to do this in Oracle. What is the equivalent in db2?...
  3. #2

    Default SELECTING ROWS

    Hi again

    Im trying to select a particular ROW in my Database,
    I want to run a query on the 1st 2nd and 3rd rows seprately.
    the information will change and only the latest 3 will be shown.

    i know of the SELECT TOP 3* but i want to run seprate querys for the link on a
    navigation bar, but im using java, and th java coding seems to get in the way.

    <p class="leftPanelBody">
    <span class="leftPanelTitle">LATEST NEWS</span><br>
    <br>
    <cfoutput query="Links">
    <span class="leftPanelLink" onMouseUp=#JavaDo#>
    <span class="leftPanelHeader">#Date#</span><br>
    #HeadLine#<br>
    --------- <br>
    </span>
    </p>
    </cfoutput>

    Ive run a SELECT TOP 3 * query agasint the above but for some reason the style
    shet dosnt work on the the last 2.
    Obviouslt the data is beening filled out beneath the tag that give the text
    the style.
    So instead of put lost of html coding in the database.
    i need to select each row at a time, i hope this is posible if not can some
    one sujest the best course of action?

    Thanks
    Craig


    MacroDuck Guest

  4. #3

    Default Re: SELECTING ROWS

    Are you sure you have your </span> tags positioned correctly?
    jdeline Guest

Posting Permissions

  • You may not post new threads
  • You may 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