How are you displaying the query? ======================================================================== === 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:59 AM > To: CF-Talk > Subject: RE: Sorting a Query Alphabetically > > > Raymond, > > This is what I've got so far: > > <CFSEARCH > NAME="phonedir" > COLLECTION="cla_intranet_phonedir" > TYPE="Simple" > CRITERIA="*#form.SearchText#*" > maxrows="100"> > > <cfquery name="phonedir_2" dbtype="query"> > SELECT * > FROM phonedir > ORDER BY > title > </cfquery> > > This is close... but when I output the results, it only > displays the first record. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4