The way to do this is definitely by creating a sequence field and ordering by this field. How the sequence is created is up to you... to hard code it you do something like
select sequence = case when 'a' then 1 when 'z' then 2 when 'f' then 3 else 4 end), next field from table The case statement will let you evaluate the field and create a sequence based on it, however, looking at your example, I think it would be wiser to add a sequence table that related each job position to a sequence and generate it this way. Justin > -----Original Message----- > From: Randell B Adkins [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 28, 2002 3:41 PM > To: CF-Talk > Subject: Re: ORDER BY question > > > Create a new field called Sequence or something. > Based on the data and the two elements you displayed > there is no way without Hard-Coding it. > > > > Randy Adkins > >>> [EMAIL PROTECTED] 05/28/02 15:39 PM >>> > ok. ASC & DESC don't work on this one. > > i want to be able to ORDER BY in a specific order > such as > ORDER BY tblJobTitle.TitleID='25,26,28,4' > > is that possible? > if not how else could i do it... > > <!--- tblJobTitle.TitleID > Partner=25 > Principal=26 > Senior Associate=28 > Associate=4 ---> > > > Thanks > > -paul > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
