Not in standard SQL. This operation would be at odds with
the relational view of data, in which data is intrinsically
not ordered.
So if there is a way of doing it that would work in a single
CFQUERY, it's going to be be DBMS-specific. If you happen
to be using PostgreSQL you might be able to to create a
user-defined function in 'C' to do it, but that would be
crazy.
But if you can't use CFOUTPUT, why does it matter what the
results look like? What exactly are you trying to do?
Nick
-----Original Message-----
From: PC [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 2:07 PM
To: [EMAIL PROTECTED]
Subject: Current Row in SQL as opposed to CF? [CF-Talk]
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.
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
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.
