How do I get a list of fields from any DB in the right order

[Puc]

Does anybody know how to retieve a field list in the right order (i.e. in the same order that the RDS gets it)?

I use all sorts of DBs though including MySQL so it has to be a generic solution.

It would be amazing if I gould get the datatypes too if anyone knows how to retrieve those.

 

[sknyppy]

Have you tried qYourQuery.ColumnList to get a list of fields in the database?

Dave

 

[CFHub]

There is a "new" custom tag that will return these in the "proper" order.

http://members.evolt.org/dshadovi/index.cfm