As this doggie understands, there is no implied order of data entry in a
"real" database like oracle, etc. and unlike some desktop databases like
FoxPro, etc.
Hence, if you want to keep track of the order in which the records are
added, you will need to insert a field and update it with a cronolgical
number or key or a down to the milisecond date/time stamp.
^
/ \__
( @\___
/ O
/ (_____/
/_____/
Whoof...
410-757-3487
-----Original Message-----
From: Andy [SMTP:[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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
