This is a multi-part message in MIME format.
------=_NextPart_000_01B0_01C02310.14845680
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Re: Current Row in SQL as opposed to CF? [CF-Talk]
Use CFLOOP instead of CFOUTPUT combined with your CFFILE operation. Keep in
mind that the currentrow variable will be determined as an incrementing
number from 1 to recordcount, and is only indicative of the physical order
in which the query was returned to CF based on your SQL statement.
DC
-----Original Message-----
From: PC [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 14:40
To: [EMAIL PROTECTED]
Subject: Re: Current Row in SQL as opposed to CF? [CF-Talk]
I am using SQL Server 7.
I can use CFOUTPUT I suppose. What I need to do is set the results to a
variable and write that as part of a file.
I am a little unclear on how I would even use CFOUTPUT in this fashion --
can I somehow
set the output to a variable?
<CFOUTPUT query="getcategories">
"Category" #currentrow# #Category_Title#
</cfoutput>
I need this in a variable that is part of a few variables concatenated and
written to a file using CFFILE write ....
Thanks for anymore insight... :)
> 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.
>
--------------------------------------------------------------------------
----
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.
------=_NextPart_000_01B0_01C02310.14845680
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: Current Row in SQL as opposed to CF? =
[CF-Talk]</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D516313414-20092000>Use=20
CFLOOP instead of CFOUTPUT combined with your CFFILE operation. =
Keep in=20
mind that the currentrow variable will be determined as an incrementing =
number=20
from 1 to recordcount, and is only indicative of the physical order in =
which the=20
query was returned to CF based on your SQL =
statement.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D516313414-20092000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D516313414-20092000>DC</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D516313414-20092000></SPAN></FONT> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> PC=20
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Wednesday, September 20, 2000=20
14:40<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Subject:</B> Re: =
Current=20
Row in SQL as opposed to CF? [CF-Talk]<BR><BR></DIV></FONT>
<P><FONT size=3D2>I am using SQL Server 7.</FONT> </P>
<P><FONT size=3D2>I can use CFOUTPUT I suppose. What I need to do is =
set the=20
results to a</FONT> <BR><FONT size=3D2>variable and write that as part =
of a=20
file.</FONT> </P>
<P><FONT size=3D2>I am a little unclear on how I would even use =
CFOUTPUT in this=20
fashion --</FONT> <BR><FONT size=3D2>can I somehow</FONT> <BR><FONT =
size=3D2>set=20
the output to a variable?</FONT> </P>
<P><FONT size=3D2><CFOUTPUT query=3D"getcategories"></FONT> =
<BR><FONT=20
size=3D2>"Category" #currentrow# #Category_Title#</FONT> =
<BR><FONT=20
size=3D2></cfoutput></FONT> </P>
<P><FONT size=3D2>I need this in a variable that is part of a few =
variables=20
concatenated and</FONT> <BR><FONT size=3D2>written to a file using =
CFFILE write=20
....</FONT> </P>
<P><FONT size=3D2>Thanks for anymore insight... :)</FONT> </P><BR><BR>
<P><FONT size=3D2>> Not in standard SQL. This operation would be at =
odds=20
with</FONT> <BR><FONT size=3D2>> the relational view of data, in =
which data=20
is intrinsically</FONT> <BR><FONT size=3D2>> not ordered.</FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>> So if there is a way of =
doing it that=20
would work in a single</FONT> <BR><FONT size=3D2>> CFQUERY, it's =
going to be=20
be DBMS-specific. If you happen</FONT> <BR><FONT size=3D2>> to be =
using=20
PostgreSQL you might be able to to create a</FONT> <BR><FONT =
size=3D2>>=20
user-defined function in 'C' to do it, but that would be</FONT> =
<BR><FONT=20
size=3D2>> crazy.</FONT> <BR><FONT size=3D2>></FONT> <BR><FONT =
size=3D2>>=20
But if you can't use CFOUTPUT, why does it matter what the</FONT> =
<BR><FONT=20
size=3D2>> results look like? What exactly are you trying to =
do?</FONT>=20
<BR><FONT size=3D2>></FONT> <BR><FONT size=3D2>> Nick</FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>> -----Original =
Message-----</FONT>=20
<BR><FONT size=3D2>> From: PC [<A=20
href=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT> =
<BR><FONT=20
size=3D2>> Sent: Wednesday, September 20, 2000 2:07 PM</FONT> =
<BR><FONT=20
size=3D2>> To: [EMAIL PROTECTED]</FONT> <BR><FONT =
size=3D2>>=20
Subject: Current Row in SQL as opposed to CF? [CF-Talk]</FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>></FONT> <BR><FONT =
size=3D2>> IS there=20
a way to do get the current row as part of a select statement =
in</FONT>=20
<BR><FONT size=3D2>a</FONT> <BR><FONT size=3D2>> similar fashion as =
the=20
coldfusion #queryname.currentrow# property</FONT> <BR><FONT=20
size=3D2>functions</FONT> <BR><FONT size=3D2>> in a CFOUTPUT =
context?</FONT>=20
<BR><FONT size=3D2>></FONT> <BR><FONT size=3D2>> What I need are =
results=20
that look like:</FONT> <BR><FONT size=3D2>></FONT> <BR><FONT =
size=3D2>>=20
Category 1 Sports</FONT> <BR><FONT size=3D2>>=20
Category 2 Languages</FONT> <BR><FONT size=3D2>>=20
Category 3 Reference</FONT> <BR><FONT size=3D2>>=20
Category 4 Politics</FONT> <BR><FONT =
size=3D2>></FONT>=20
<BR><FONT size=3D2>> from a query looking something like:</FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>> SELECT TOP 4 Category + =
?currentrow?=20
+ Category_title</FONT> <BR><FONT size=3D2>></FONT> <BR><FONT =
size=3D2>> So=20
what property exists, or technique for generating the ?currentrow? =
part</FONT>=20
<BR><FONT size=3D2>> of the statement above????</FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>> Now, I cannot use the =
indentity field=20
.. I don't want values like</FONT> <BR><FONT size=3D2>> Category =
2 =20
...</FONT> <BR><FONT size=3D2>> Category 19 ...</FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>> And ... I cannot use a =
CFOUTPUT or=20
CFLOOP -- I want to do it all in the</FONT> <BR><FONT =
size=3D2>SQL</FONT>=20
<BR><FONT size=3D2>> statement if possible!!</FONT> <BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>></FONT> <BR><FONT =
size=3D2>>=20
=
-------------------------------------------------------------------------=
-</FONT>=20
<BR><FONT size=3D2>--</FONT> <BR><FONT size=3D2>> --</FONT> =
<BR><FONT=20
size=3D2>> Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>> To Unsubscribe visit</FONT> <BR><FONT =
size=3D2>> <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or</FONT> <BR><FONT size=3D2>> send a message to=20
[EMAIL PROTECTED] with 'unsubscribe' in</FONT> =
<BR><FONT=20
size=3D2>> the body.</FONT> <BR><FONT size=3D2>></FONT> =
<BR><FONT=20
size=3D2>></FONT> <BR><FONT size=3D2>>=20
=
**********************************************************************</F=
ONT>=20
<BR><FONT size=3D2>> Information in this email is confidential and =
may be=20
privileged.</FONT> <BR><FONT size=3D2>> It is intended for the =
addressee=20
only. If you have received it in error,</FONT> <BR><FONT size=3D2>> =
please=20
notify the sender immediately and delete it from your system.</FONT> =
<BR><FONT=20
size=3D2>> You should not otherwise copy it, retransmit it or use =
or disclose=20
its</FONT> <BR><FONT size=3D2>> contents to anyone.</FONT> =
<BR><FONT=20
size=3D2>> Thank you for your co-operation.</FONT> <BR><FONT =
size=3D2>>=20
=
**********************************************************************</F=
ONT>=20
<BR><FONT size=3D2>>=20
=
-------------------------------------------------------------------------=
-</FONT>=20
<BR><FONT size=3D2>----</FONT> <BR><FONT size=3D2>> Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>> To Unsubscribe visit</FONT> <BR><FONT =
size=3D2><A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or</FONT> <BR><FONT size=3D2>send a message to =
[EMAIL PROTECTED]=20
with 'unsubscribe' in</FONT> <BR><FONT size=3D2>the body.</FONT> =
<BR><FONT=20
size=3D2>></FONT> </P>
<P><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_01B0_01C02310.14845680--
------------------------------------------------------------------------------
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.
