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.
--
Jillian
> -----Original Message-----
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: July 10, 2003 10:54 AM
> To: CF-Talk
> Subject: RE: Sorting a Query Alphabetically
>
>
> 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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
