Hello all,
I've created a search page where a user can type in a few key words to
search on that returns only active items. The key words will be searching
through indexed properties. I don't believe that there is a way to filter
this search through the cfa_propertySearch tag to only pull out active
objects. So I came up with this multi-step filtering process. Is this
efficient, or is there a better / faster way?
Thanks in advance,
Nate
-----
<!--- process the search request --->
<CFIF ISDEFINED("form.Submit")>
<!--- search verity for the following props --->
<CFA_propertySearch
DATASOURCE="#request.cfa.objectstore.dsn#"
BDISTINCTOBJECT="yes"
SEARCHTERMS="#form.Criteria#"
LPROPERTIES="402B0328-6BA0-11D3-AD4D0060B0EB2994_DESCRIPTION,402B0313-6BA0-1
1D3AD4D0060B0EB2994_host,402B0313-6BA0-11D3-AD4D0060B0EB2994_TITLE"
RESULTSET="key"
R_QRESULTS="qProps"
>
<!--- filter the objects to make sure they are active --->
<CFA_contentObjectGetMultiple
bActiveOnly="yes"
bACTIVE="yes"
DATASOURCE="#request.cfa.objectstore.dsn#"
LOBJECTIDS="#VALUELIST(qProps.objectid)#"
R_QOBJECTS="qActive"
>
<!--- display the filtered objects --->
<CFA_contentObject
DATASOURCE="#request.cfa.objectstore.dsn#"
LOBJECTIDS="#VALUELIST(qActive.objectid)#"
METHOD="display"
>
</CFIF>
-
Nate Smith,
Lead Developer
[EMAIL PROTECTED]
www.doceus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
