I have this code <cfset q=application.fapi.getContentObjects(typename="dmFile", CATFILE_in=stObj.metadata, orderby="documentDate DESC",maxRows=maximumRows)> which dumped looks like this
q - queryRESULTSETq - query OBJECTIDTYPENAMECACHEDfalseEXECUTIONTIME0SQLselect objectid, 'dmFile' as typename from dbo.dmFile where 1=1 AND status in (?,?,?) AND objectid in ( select objectid from dbo.refCategories where categoryid in (?) ) ORDER BY documentDate DESCSQLPARAMETERSq - array1draft2 pending3approved4B6BD1DF6-1AA0-353A-5A6C82D7C341D430 If I cut and paste the SQL into a query I get data select objectid, 'dmFile' as typename from dbo.dmFile where 1=1 AND status in (<cfqueryparam cfsqltype="cf_sql_varchar" value="approved,draft,pending" list="true">) AND objectid in ( select objectid from dbo.refCategories where categoryid in (<cfqueryparam cfsqltype="cf_sql_varchar" value="B6BD1DF6-1AA0-353A-5A6C82D7C341D430" list="true">) ) ORDER BY documentDate DESC q1 - queryRESULTSETCACHEDfalseEXECUTIONTIME0SQLselect objectid, 'dmFile' as typename from dbo.dmFile where 1=1 AND status in (?,?,?) AND objectid in ( select objectid from dbo.refCategories where categoryid in (?) ) ORDER BY documentDate DESCSQLPARAMETERSq1 - array1approved2draft3pending4 B6BD1DF6-1AA0-353A-5A6C82D7C341D430 What is going on here? -- *AJ Mercer* <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org community="Open" /> <http://webonix.org> http://twitter.com/webonix -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
