To get High to appear before Middle, you'd need to add a "sort" column to your school type database.
Add a char (1) column and then manipulate that to affect the sort. Then in your query you do ORDER BY sort ASC. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Steven Sprouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 11:19 AM To: CF-Talk Subject: Re: Need help building pages with multiple queries and tables Okay, working brilliantly! Take a look at my page so far http://www.ccboe.com/website/schoolscenters/schools_main.cfm How do I sort so that Elementary is First, Middle is Second, High is Third and Center/Program is Fourth? Their respective SchoolTypeIDs are 1,2,3,4 Thanks so much for all of the help! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247064 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
