Print Page | Close Window

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 *
FROM tbl_names
WHERE Fname like 'Chris'
ORDER BY Lname

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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net