I am running this on CF9 and this function is generating SQL with 2 single quotes
'dmFile' as typename turns into ''dmFile'' as typename (2 single quotes, not one double quote) On 23 December 2010 11:08, AJ Mercer <[email protected]> wrote: > sorry, that was me experimenting without order by > > q - query RESULTSET q - query OBJECTID TYPENAME CACHEDfalseEXECUTIONTIME > 0 SQLselect objectid, 'dmFile' as typename from dbo.dmFile where 1=1 AND > status in (?) ORDER BY documentDate DESC SQLPARAMETERS q - array 1approved > > 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 > -- *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
