Query of query, since cfsearch doesn't sort for you. ======================================================================== === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email : [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 10, 2003 10:49 AM > To: CF-Talk > Subject: Sorting a Query Alphabetically > > > Today is the day for me to have brain-freeze it seems! > > I want to order a search query by last_name instead of > relevance... What's the best/easiest way to do this? > > My CFSEARCH tag: > > <CFSEARCH > NAME="phonedir" > COLLECTION="cla_intranet_phonedir" > TYPE="Simple" > CRITERIA="*#form.SearchText#*" > MAX ROWS="100"> > > My Indexing Tag (this works): > > <cfindex action="refresh" > collection="cla_intranet_phonedir" > Key="person_id" > type="Custom" > title="last_name" > query="GetResults" > custom1="first_name" > custom2="org_id" > body="last_name, first_name, email"> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
