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.
