Arranging Query Columns

[Maneesh Tikkiwal]

This is my query

<cfset Totals =
queryNew("TotalPointsEarned,EarnedPointsCost,Total PointsRedeemed,RedeemedPointsC
ost,PointsreedemedHandling,RedemedTotal,TotalPoint sUnRedeemed,UnRedeemedPointsCo
st,PointsUnreedemedHandling,UnRedemedTotal")>
<cfset queryAddRow(Totals)>
<cfset querySetCell(Totals, "TotalPointsEarned",
"#DecimalFormat(TotalPointsEarned)#")>
<cfset querySetCell(Totals, "EarnedPointsCost",
"#DecimalFormat(EarnedPointsEarned)#")>
<cfset querySetCell(Totals, "TotalPointsRedeemed",
"#DecimalFormat(ALLTotalPoints)#")>
<cfset querySetCell(Totals, "RedeemedPointsCost",
"#DecimalFormat(ALLPoints_Cost)#")>
<cfset querySetCell(Totals, "PointsreedemedHandling",
"#DecimalFormat(Handling)#")>
<cfset querySetCell(Totals, "RedemedTotal", "#DecimalFormat(Total)#")>
<cfset querySetCell(Totals, "TotalPointsUnRedeemed",
"#DecimalFormat(ALLTotalUnredeemed)#")>
<cfset querySetCell(Totals, "UnRedeemedPointsCost",
"#DecimalFormat(ALLUnredeemed_points)#")>
<cfset querySetCell(Totals, "PointsUnreedemedHandling",
"#DecimalFormat(Unred_Handling)#")>
<cfset querySetCell(Totals, "UnRedemedTotal",
"#DecimalFormat(TotalHandling)#")>

<cfdump var="#totals#"><cfabort>

The problem is, if I dump it, the query doen't put the cells in the same order
as I have created them. It autoArranges it to Alphabetical Order. Can anyone
Help please?

This is the sequence I want.

TOTALPOINTSEARNED
EARNEDPOINTSCOST
TOTALPOINTSREDEEMED
REDEEMEDPOINTSCOST
POINTSREEDEMEDHANDLING
REDEMEDTOTAL
TOTALPOINTSUNREDEEMED
UNREDEEMEDPOINTSCOST
POINTSUNREEDEMEDHANDLING
UNREDEMEDTOTAL

But, this is the sequence I get.


EARNEDPOINTSCOST
POINTSREEDEMEDHANDLING
POINTSUNREEDEMEDHANDLING
REDEEMEDPOINTSCOST
REDEMEDTOTAL
TOTALPOINTSEARNED
TOTALPOINTSREDEEMED
TOTALPOINTSUNREDEEMED
UNREDEEMEDPOINTSCOST
UNREDEMEDTOTAL

Any help will be much appriciated.

Cheers.

[paross1]

Why are you using CFDUMP to display our output? This tag is intended as a tool
that Outputs variables for debugging purposes. Using cfdump, you can display
the contents of simple variables, queries, arrays, structures, and WDDX
variables created with cfwddx.

Phil

[Maneesh Tikkiwal]

cfdump is just for testing. don't worry about that. if you know the answer to my query please do let me know.

[paross1]

The answer is, if you use CDFUMP, you are stuck with the column names being
sorted alphabetically. That is why I was implying as to why you would care
about the sort order ,unless you actually planned on using CFDUMP for anything
other than for testing and debugging. So, if you want to control the order of
the columns, don't use CFDUMP.

Phil

[Maneesh Tikkiwal]

Hello Phill/ everyone.

I do not intend to use cfdump for other then testing purposes. I am using this
code to export the resul to excel using the custom tag QueryToExcel, I am
passing the values as below

<cfset Totals =
queryNew("TotalPointsEarned,EarnedPointsCost,Total PointsRedeemed,RedeemedPointsC
ost,PointsreedemedHandling,RedemedTotal,TotalPoint sUnRedeemed,UnRedeemedPointsCo
st,PointsUnreedemedHandling,UnRedemedTotal")>
<cfset queryAddRow(Totals)>
<cfset querySetCell(Totals, "TotalPointsEarned",
"#DecimalFormat(TotalPointsEarned)#")>
<cfset querySetCell(Totals, "EarnedPointsCost",
"#DecimalFormat(EarnedPointsEarned)#")>
<cfset querySetCell(Totals, "TotalPointsRedeemed",
"#DecimalFormat(ALLTotalPoints)#")>
<cfset querySetCell(Totals, "RedeemedPointsCost",
"#DecimalFormat(ALLPoints_Cost)#")>
<cfset querySetCell(Totals, "PointsreedemedHandling",
"#DecimalFormat(Handling)#")>
<cfset querySetCell(Totals, "RedemedTotal", "#DecimalFormat(Total)#")>
<cfset querySetCell(Totals, "TotalPointsUnRedeemed",
"#DecimalFormat(ALLTotalUnredeemed)#")>
<cfset querySetCell(Totals, "UnRedeemedPointsCost",
"#DecimalFormat(ALLUnredeemed_points)#")>
<cfset querySetCell(Totals, "PointsUnreedemedHandling",
"#DecimalFormat(Unred_Handling)#")>
<cfset querySetCell(Totals, "UnRedemedTotal",
"#DecimalFormat(TotalHandling)#")>

The problem is, on the excel sheet, its not coming as I have defined them. The
column names are sorted in alphabetical order and are not displayed in the
sequence as I create them.

Any help will be much appriciated.

Regards

[Adam Cameron]

> I do not intend to use cfdump for other then testing purposes. I am using this

> code to export the resul to excel using the custom tag QueryToExcel, I am
> passing the values as below

Does this QueryToExcel custom tag (I can find no reference to this custom
tag on google) not permit you to specify which order to process the
columns?

You're kind of at the mercy of how QueryToExcel has been coded...

--
Adam

[jdeline]

Have you looked at CFX_Exce at [url]http://www.cftagstore.com/tags/cfxexcel.cfm?[/url] Maybe that will suit your purpose.