<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> </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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
