Ask a Question related to Coldfusion Database Access, Design and Development.
-
MacroDuck #1
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
-
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... -
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: ... -
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... -
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... -
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?... -
MacroDuck #2
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
-
jdeline #3
Re: SELECTING ROWS
Are you sure you have your </span> tags positioned correctly?
jdeline Guest



Reply With Quote

