Your main problem is that you should not be using propertysearch. I believe
that tag is going to be removed soon - certainly it should not be used. Use
TypeSearch instead. It automatically filters out inactive obs unless you
pass in bActiveOnly=0.
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Nate Smith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 1:09 PM
> To: Spectra-Talk
> Subject: Search and Filter for Active Content Objects
>
>
> 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,402B0
> 313-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.
