Column order

[t047554]

Hi, I have a problem , I can't retreive the fields in the same order (like in
the table) when I use the CFDump
I have the column in a alphabetique order but not in the same order like the
table.
I just want to have a CFQuery and display the data in the same order (like
the table)

Thank's for your help

PS: sorry for my bad english ;)

[rmorgan]

Hopefully you have an autonumber primary key. If you do just add the line ORDER
BY primary_key to your query. You can also do ORDER BY primary_key asc or desc.
Using asc or desc can change the order in which you will see it displayed.

[t047554]

Thank you for the replie, but I think it have nothing to do with the column order but with the data order (I think)

[rmorgan]

This is what order by function is for, its been awhile since I used cfdump,
cant remember its parameters or if changes the data order by default.

Check it out and see what it does, it should give you what you want.

[paross1]

CFDUMP is going to give you your columns in alpha order. You can use cfgrid and
use cfgridcolumn tags to specify your column order, or you can use a table in
the same way, or you can just use cfoutput with a guery attribute, and list
your column names in the order in which you wish for them to appear.

Phil

[t047554]

Thank's Paross1, but I want to find some think like CFDUMP but with no change
in the column order.
If I use CFDUMP, I don't need to specifie all the columns name for the output.
Or is it possible to retreive in a easy way the columns name in the original
way (not aphabetique order).
My problem is that I have made a query that can use differente table, and the
table don't have all the same structure (columns name)

Thank's for your help

[rmorgan]

It appears as if you are trying to use cfdump in a production app. cfdump is
not intended for this, its purpose is for troubleshooting only, it just shows
the data so you can see if the data you are looking for is at least there. This
is why you are seeing limitations, this tag just does not have many attributes
built into it, 3 if i recall. You should rethink what you are trying to do, and
use another tag. Like paross suggested, there are a couple options, cfgrid and
its child tags, and a dynamic table should work just fine for you, the other
tags are more than capable of displaying your data the way you want.

[paross1]

FYI, one thing that I discovered recently is that using CFGRID without any
CFGRIDCOLUMN tags will return all of the columns in the same order as they
appear in your query when using CFMX 7. (CFMX 6.x will return the columns in
alpha order, so this looks like something that was "fixed" with MX 7.)

Phil

[JMGibson3]

[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=3&threadid=961231[/url]