I believe there is a CFX tag that will do this. If I remember correctly, it
works with SQL Server, but I don't know about Oracle.
Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
-----Original Message-----
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:39 PM
To: CF-Talk
Subject: Re: unsorted QueryName.ColumnList?
Atne,
Been down this road. Don't remember the answer. Go to HouseOfFusion and
search the list.
Andy
----- Original Message -----
From: "Boskovic, Ante" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 10:04 AM
Subject: unsorted QueryName.ColumnList?
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C0A269.4E0587E8
> Content-Type: text/plain;
> charset="iso-8859-1"
>
>
> CF server 4.5 returns QueryName.ColumnList variable sorted alphabetically.
> Is there a way to get the column names in unsorted manner? My goal is to
> have them as they are ordered in the Oracle database table.
> Thanks in advance.
>
>
> ------_=_NextPart_001_01C0A269.4E0587E8
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2448.0">
> <TITLE>unsorted QueryName.ColumnList?</TITLE>
> </HEAD>
> <BODY>
> <BR>
>
> <P><FONT SIZE=3D2>CF server 4.5 returns QueryName.ColumnList variable =
> sorted alphabetically. Is there a way to get the column names in =
> unsorted manner? My goal is to have them as they are ordered in the =
> Oracle database table.</FONT></P>
>
> <P><FONT SIZE=3D2>Thanks in advance.</FONT>
> </P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01C0A269.4E0587E8--
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
