The problem is that any row number associated with a row isn't going to
be in order. What you call row 1 may be stored in the database as row
1567. It only becomes row 1 because your SQL statement selects it as row
1. So you're forced to use properties of the result set, i.e.
#queryname.currentrow#.
-David
On Wed, 20 Sep 2000 06:07:26 -0700 PC <[EMAIL PROTECTED]> writes:
> IS there a way to do get the current row as part of a select
> statement in a
> similar fashion as the coldfusion #queryname.currentrow# property
> functions
> in a CFOUTPUT context?
>
> What I need are results that look like:
>
> Category 1 Sports
> Category 2 Languages
> Category 3 Reference
> Category 4 Politics
>
> from a query looking something like:
>
> SELECT TOP 4 Category + ?currentrow? + Category_title
>
> So what property exists, or technique for generating the
> ?currentrow? part
> of the statement above????
>
> Now, I cannot use the indentity field .. I don't want values like
> Category 2 ...
> Category 19 ...
>
> And ... I cannot use a CFOUTPUT or CFLOOP -- I want to do it all in
> the SQL
> statement if possible!!
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
