You can dump the query.ColumnList into a new variable and re-sort it however
you please, perhaps using ListSort().
-----Original Message-----
From: Williams, Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 5:15 PM
To: CF-Talk
Subject: Query columnlist order in 4.0?
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_01C05033.DC1C902C
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
Does anybody know how CF 4.0 sets the order of the query.columnlist
attribute? I'm trying to use the query2excel custom tag and want to be able
to control the layout of the columns.
In 4.5, I can control this order by creating aliases for each field in the
SQL statement with an alphabetical order for which I want to set them. But,
in 4.0 I can't control them in this way, and can't figure out how the order
is determined.
Any help is appreciated. Thank you.
------_=_NextPart_001_01C05033.DC1C902C
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.2650.12">
<TITLE>Query columnlist order in 4.0?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Does anybody know how CF 4.0 sets the =
order of the<B> query.columnlist</B> attribute? I'm trying to use =
the query2excel custom tag and want to be able to control the layout of =
the columns.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">In 4.5, I can control this order by =
creating aliases for each field in the SQL statement with an =
alphabetical order for which I want to set them. But, in 4.0 I =
can't control them in this way, and can't figure out how the order is =
determined.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Any help is appreciated. Thank =
you.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C05033.DC1C902C--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com
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
https://secure.houseoffusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
