I just discovered my own problem!!! I needed to add _2 to #phonedir.key# in the WHERE clause.
-- Jillian > -----Original Message----- > From: Jillian Carroll [mailto:[EMAIL PROTECTED] > Sent: July 10, 2003 11:08 AM > To: CF-Talk > Subject: RE: Sorting a Query Alphabetically > > > <cfoutput query="phonedir_2"> > <!--- Select various user details for output ---> > <cfquery name="details" datasource="#DSN#"> > SELECT person.*, > organization.name > FROM person > JOIN organization ON > organization.organization_id = person.organization_id > WHERE person_id = #phonedir.key# > </cfquery> > > <cfloop query="details"> > <tr class="NoHoverColor" > onMouseOver="this.className = 'HoverColor';" > onMouseOut="this.className = 'NoHoverColor';"> > <td class="first"><a > href="directory_details.cfm?id=#phonedir.key#">#last_name#, > #first_name#</a></td> > <td><cfif > isDefined('organization_id')>#name#<cfelse>Not Specified</cfif></td> > <td><cfif isDefined('email')><a > href="mailto:#email#";>#email#</a><cfelse>Not Specified</cfif></td> > <td><cfif > isDefined('work_phone')>#work_phone# <cfelse>Not > Specified</cfif></td> > <td class="last" align="center"><cfif > isDefined('work_phone_ext')>#work_phone_ext# <cfelse>&nbs > p;</cfif></td> > </tr> > </cfloop> > </cfoutput> > > > -----Original Message----- > > From: Raymond Camden [mailto:[EMAIL PROTECTED] > > Sent: July 10, 2003 11:04 AM > > To: CF-Talk > > Subject: RE: Sorting a Query Alphabetically > > > > > > 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 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
