technically, you can't do this. some other people have suggested solutions
that will give you a close approximation of "the second row". the problem
(there is no fault with the suggestions or code) is that the concept of "the
second row" is not a constant. because of the way RDBMS systems work,
You have to look at it this way, a query will only return what you ask it to
return. So without knowing what you want you can really only return the
entire list...
Now having said this, if you did return the entire list from the DB. You
know how many records there are because of the RecordCount.
Well, there are several ways you could go:
- Run the query to grab the entire table. Then reference the query as
though it's a CF-structure; or
- Run the query using STARTROW=2 and MAXROWS=1 to stop at row 2, then use
queryname.columnlist, listgetat(), and evaluate() to fetch the data from
column
3 matches
Mail list logo