thanks to all that responded to my request for info. i didn't think there was a way to get the columns unsorted. I wasn't actually going to depend on the order for any critical formatting or anything. It's just aggrevating that MM would just asssume that everyone would want the columns pre-sorte
Thank you barney for your input. I didn't think this was possible but just wanted to check.
-mark
>Nope sure isn't, and believe me, you don't want to be able to. Doing
> so creates a dependancy on the order of the columns in your database
> and/or SQL statement (depending on if you use SELECT
>>When you are writing a general-purpose table-independent db client or
maintenance program.
Right, and this is the main reason I wrote CFX_ODBCinfo.
(see the link below).
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagst
There is at least one instance where it is useful to have the column
names returned in the order they are defined.
When you are writing a general-purpose table-independent db client or
maintenance program.
In almost every case, there is some logic to the order in which table
columns are define
Nope sure isn't, and believe me, you don't want to be able to. Doing
so creates a dependancy on the order of the columns in your database
and/or SQL statement (depending on if you use SELECT * or not), which
is almost guarenteed to cause problems down the road when you
add/update/remove a column f
I know I've seen this on a list before but couldn't remember where. When displaying or using the cfquery.columnList variable, the columns are automatically sorted in alphanumeric order. Is there any way to retrieve the columnlist in the order it was returned by SQL-Server -- which is the order as
6 matches
Mail list logo
