Remove the stProperties thing. Remove bActiveOnly.
Try: bActive=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: Thursday, March 29, 2001 4:11 PM
> To: Spectra-Talk
> Subject: What's wrong with this CFA_contentObjectFind?
>
>
> Hi all,
>
> I'm trying to search my content objects to see what objects are inactive.
> Then I want to give my admins a chance to make them approved and active.
> However, my cfa_contentObjectFind doesn't seem to be working. I
> get back ALL
> my objects. Not just the inactive objects. What am I missing?
>
> Thanks,
> Nate
>
> -----
>
> <CFSCRIPT>
> stProperties = STRUCTNEW();
> stProperties.attr_active = 1;
> </CFSCRIPT>
>
> <cfa_contentobjectfind
> dataSource = "#request.cfa.objectstore.dsn#"
> typeID = "#url.TypeID#"
> stProperties = "#stProperties#"
> lPropertiesPrecedence="attr_active"
> bActiveOnly = "0"
> bNonArchivedOnly = "0"
> r_stObjects = "stAllObjects"
> >
>
> <CFA_structSortCommonSubkeys
> STRUCT="#stAllObjects#"
> COMMONSUBKEY="label"
> R_ASORTEDKEYS="aSortedByLabel"
> >
>
> <CFLOOP LIST="#ARRAYTOLIST(aSortedByLabel)#" INDEX="stObject">
>
> <CFOUTPUT>#EVALUATE("stAllObjects['#stObject#'].label")#</CFOUTPUT><BR>
> </CFLOOP>
>
> -
> 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.