is any one running Farcry 6 on CF9?
On 23 December 2010 13:19, AJ Mercer <[email protected]> wrote: > 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 1 >> approved >> >> 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 > -- *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
