sorry, i wrote that kinda fast but i was trying to avoid any more columns in the db if possible. If i cant come up with a better way then im going to just put a column that holds the letter that would return the current row
----- Original Message ----- From: "Venn, Matthew" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 5:03 PM Subject: RE: ahhh query > You can create an additional db field that would contain a search name. > > Display name, Search name > University of Alabama, Alabama University of > Florida State University, Florida State University > The BlahBlah Institute, BlahBlah Institute The > The University of Chicago, Chicago The University of > > > -----Original Message----- > From: Ewok [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 23, 2002 4:05 PM > To: CF-Talk > Subject: ahhh query > > > 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
