sorry, that was me experimenting without order by q - queryRESULTSETq - query OBJECTIDTYPENAMECACHEDfalseEXECUTIONTIME0SQLselect objectid, 'dmFile' as typename from dbo.dmFile where 1=1 AND status in (?) ORDER BY documentDate DESCSQLPARAMETERSq - array1approved On 23 December 2010 06:55, Blair McKenzie <[email protected]> wrote:
> Interesting - the order by clause is missing. > On 22/12/2010 12:10 PM, "AJ Mercer" <[email protected]> wrote: > > <cfset q=application.fapi.getContentObjects(typename="dmFile", > > orderby="documentDate DESC",maxRows=maximumRows)> > > > > returns > > q - queryRESULTSETq - query > OBJECTIDTYPENAMECACHEDfalseEXECUTIONTIME16SQLselect > > objectid, 'dmFile' as typename from dbo.dmFile where 1=1 AND status in > (?) > > SQLPARAMETERSq - array1approved > > > > > > > > > > On 22 December 2010 07:20, Geoff Bowers <[email protected]> wrote: > > > >> No idea. Looks very odd to me. > >> > >> getContentObjects() seems to work just fine for me. Do you get any > results > >> is you remove the category filter? > >> > >> -- geoff > >> http://www.daemon.com.au/ > >> skype. gb.daemon > >> > >> -- > >> You received this message cos you are subscribed to "farcry-dev" Google > >> group. > >> To post, email: [email protected] > >> To unsubscribe, email: > >> [email protected]<farcry-dev%[email protected]> > <farcry-dev%[email protected]<farcry-dev%[email protected]> > > > > >> For more options: http://groups.google.com/group/farcry-dev > >> -------------------------------- > >> Follow us on Twitter: http://twitter.com/farcry > > > > > > > > > > -- > > > > *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]<farcry-dev%[email protected]> > > For more options: http://groups.google.com/group/farcry-dev > > -------------------------------- > > Follow us on Twitter: http://twitter.com/farcry > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: > [email protected]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > -- *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
