ok, so ive decided to go with the Letter column in the db lol thnx for the input ----- Original Message ----- From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 5:27 PM Subject: Re: ahhh query
> There are smarter/faster/bettter ways. But here is one. > > Create a second field, and have that be the name for selection purposes. Then sort by actual name. > > When you insert into the db, put the data in two fields, RealName and NewName. > > If you don't want to precalc this data, or can't , you can do it live, but it will cost. > > I think a simple mask of words you DONT care about can solve this. > > Build a list of words that do not matter for the sort. > <cfset IgnoreList="university,of,the,college,institute"> > > select em all. > create a list of the name column ValueList() > replace each word in the ignore list with "" (cfloop through ignore list, replacing with newNameList with "") > list to array > add a column to the query, populating with array (queryAddColumn > query of query to get the list for "A", order by original name field > > It ain't quick, but it might work. > > > > >>> [EMAIL PROTECTED] 05/23/02 05:05PM >>> > blahhhh... > > I have a template topped by the alphabet, all letters are links and they > need to display the correct info from the database on the page when clicked, > However the info that is being sorted will be names such as..... > > University of Alabama (A) > Florida State University (F) > The BlahBlah Institute (B) > The University of Chicago (C) > > > so basically the word I need to check the first letter of could be ANYHWERE > in the name > > > ANY and ALL ideas are appreciated.......(short of finding a new line of > work) : ) > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
