Nate-

I'm not sure there would be a way to pull back only inactive, but your best
bet would be to change that property filter below to '0' instead of 1. 

-----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.

Reply via email to