Sorting
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1153
Printed Date: 29 March 2026 at 10:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Sorting
Posted By: jaz9090
Subject: Sorting
Date Posted: 19 March 2003 at 1:04pm
|
In a database driven, profile list i would like to arrange my links by surname a-z, i have fould this peice of code: strSQLQuery = "SELECT * FROM tablename ORDER BY Name DESC" Which should work exept my names are in one field I.e. Name - Joe Bloggs instead of Forname- joe Surname - Bloggs, is there eny way to modify this code to sort it a-z by first letter on second word? otherwise i am going to have to rebuild my profile manager which coukd take a quite some of time
Thanks James p.s. i will remember to use 2 boxes for names in the future |
Replies:
Posted By: MorningZ
Date Posted: 19 March 2003 at 2:11pm
|
you could do a substring in the SQL statement, but it wil be A LOT of strain on your database to do so if there are a lot of records
recommendation: take the time and split the name up ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: fernan82
Date Posted: 19 March 2003 at 4:39pm
|
Take a look at how is done on the members.asp file of the forums... ------------- FeRnAN http://www.danasoft.com/"> 
|
Posted By: Bunce
Date Posted: 20 March 2003 at 4:17am
|
Also, change the name of your NAME field to something else... NAME is a reserved word in some databases. ------------- There have been many, many posts made throughout the world... This was one of them. |
Posted By: MorningZ
Date Posted: 20 March 2003 at 7:39am
|
and if there is any worry about using a reserved word, you can also simply always reference by [Name] ------------- Contribute to the working anarchy we fondly call the Internet |