Alphabetic order
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=1900
Printed Date: 29 March 2026 at 7:45pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Alphabetic order
Posted By: Mart
Subject: Alphabetic order
Date Posted: 18 April 2003 at 1:22pm
|
How can I pull things out of a database in alphabetic order not the order in which it was added? Thanks, Martin. |
Replies:
Posted By: glypher
Date Posted: 18 April 2003 at 2:14pm
|
select from where orderby that should be your mantra. SELECT * it's the "order by" that determines it. ------------- glypher said so. http://www.gainesvillebands.com - GainesvilleBands.com |
Posted By: Mart
Date Posted: 18 April 2003 at 3:03pm
|
I can't seem to get that to work is this right? SQL = "SELECT tblMP3.Artist, tblMP3.Track, tblMP3.Genre, tblMP3.Comments, tblMP3.URL, tblMP3.autonum FROM tblMP3 ORDER BY Lname;" Thanks, Martin. |
Posted By: michael
Date Posted: 18 April 2003 at 3:29pm
 you would wann do something like ORDER BY tblmp3.Artist or whom ever you wanna sort by------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Mart
Date Posted: 20 April 2003 at 7:44am
Ok thanks its sorted now.
|