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:NSmith@doceus.com] 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 nsmith@doceus.com 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 spectra-talk-request@houseoffusion.com with 'unsubscribe' in the body.