Ask a Question related to Coldfusion Database Access, Design and Development.
-
sc #1
sort tablename in sql table
hi.. i have several tables where I need to sort the column name in a table;
asc order.. how can i do that?
ex: table is abc
column name: yahoo, msn, google
I want to sort the column to
google, msn, yahoo
TIA.
sc Guest
-
Sort Table Feature
Has anyone else received the following javascript error when attempting to sort a table with DreamWeaver 8? TypeError:... -
Sort a repeat region in a table by clicking on the table headers
Sort a repeat region in a table by clicking on the table headers for ASP some help on this topic pls.. Rgds MeTin -
To sort the table per fields
Hi alll can anyone tell me how i can make links with one recordset (or more) which each link is gonna sort the etails on the table for example my... -
Table sort
Hi I would like sort table. The table is createobject method (open a function and use SAP connection) and the table not use recordset. is it... -
Drop table <tablename> failling
I created a very simple table in db2, the prompt gave a success message. but when I try to do a describe or select or insert or basically anything... -
mxstu #2 Re: sort tablename in sql table
If I'm understanding you correctly, you want to sort by the "google" column,
then the "msn" column and finally the "yahoo" column. Just use an order by
clause. The default is "asc" (ascending order)
--- not tested
SELECT google, msn, yahoo
FROM abc
ORDER BY google, msn, yahoo
mxstu Guest
-
sc #3 Re: sort tablename in sql table
No! I want to sort the column name (fieldnames) in the table. not do a
sort by in a query..
"mxstu" <webforumsuser@macromedia.com> wrote in message
news:dh7644$f9g$1@forums.macromedia.com...> If I'm understanding you correctly, you want to sort by the "google"
> column,
> then the "msn" column and finally the "yahoo" column. Just use an order
> by
> clause. The default is "asc" (ascending order)
>
> --- not tested
> SELECT google, msn, yahoo
> FROM abc
> ORDER BY google, msn, yahoo
>
sc Guest
-
Dan Bracuk #4 Re: sort tablename in sql table
The query.columnlist is sorted alphabetically if that's what you want.
Dan Bracuk Guest
-
mxstu #5 Re: sort tablename in sql table
Okay. That was not quite clear. If you just want to sort the literal names, then the "columnList" variable is probably what you're looking for.
mxstu Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
