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!!
------------------------------------------------------------------------------
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.
