|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Alphabatizing |
|
From: |
Harlan |
|
Date: |
2/10/1999 2:19:37 PM |
|
IP: |
206.222.20.2 |
add "order by [fieldName]" on your sql statement to sort your records the same as that field.
an example for access
you have a table named tblTable with 3 columns
cmnOne string,cmnTwo int,cmnThree auto.
in access click the a->z button to sort the
cmnOne field from a to z. Then in your select
"select cmnOne,cmnTwo,cmnThree from tblTable order by cmnOne"
your returned recordset would then be sorted alphabetically. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
