Hi, I am attempting to query the results of a cfsearch on verity collections to check for expired objects, however the column I want to reference that holds objectids is named "key". My guess why I can't do it is that this is a reserved SQL term. Is there a workaround for this?
On a similar Verity theme, for time-sensitive object types would it be possible to add a config to exclude expired objects when creating the collections? Or, could this be achieved by making custom2 configurable to expiry date or other custom details and using this to query the cfsearch results? Can this be done with the new extensibility of FarCry? farcry_core/packages/farcry/_verity/verityupdate.cfm: <cfindex action="UPDATE" query="q" body=" #arrayToList(application.config.verity.contenttype[key].aprops)#" custom1=" #key#" key="objectid" title="label" collection=" #application.applicationname#_#key#"> Regards, Natalie --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
