Blair, how can i do that? We've downloaded latest version from svn, it is 6.1.0. But when i replace current core with the new one, i am getting an error like: Element default is undefined in a CFML structure referenced as part of an expression. C:\inetpub\wwwroot\farcry\core\packages\lib\db.cfc:89
What does that mean? Thanks, Mika On Apr 27, 4:18 am, Blair McKenzie <[email protected]> wrote: > Have you thought of passing in your restrictions using the sqlwhere > attribute instead of passing in an entire recordset? > > Blair > > > > > > > > On Wed, Apr 27, 2011 at 6:43 AM, smika <[email protected]> wrote: > > Hi, > > > we've upgrade core to version 6.0.11, and suddenly filtering in admin > > stopped working. I've found post and fix by Tomek, according to which > > i need to replace <cfoutput>AND #i# LIKE '%#whereValue#%'</cfoutput> > > by > > <cfoutput>AND lower(#i#) LIKE '%#whereValue#%'</cfoutput> in > > objectadmin.cfm under tags/formtools. > > > Filtering start working only if there is no custom query defined. For > > example: > > <cfset stFilterMetaData = structNew() /> > > > <cfset stFilterMetaData.title.ftValidation = "" /> > > <cfquery name="latestArticles" datasource="#application.dsn#"> > > Select > > objectID,title,publishDate,secArticle,priority,bCommented,status from > > ctArticle > > where publishDate > Date_Add(now(), INTERVAL -90 DAY) > > order by publishdate desc > > </cfquery> > > <cfset aCustomColumns = arraynew(1) /> > > <cfset aCustomColumns[1] = structnew() /> > > <cfset aCustomColumns[1].title = "Author 1"/> > > <cfset aCustomColumns[1].webskin = "displayAuthor1" /> > > <cfset aCustomColumns[2] = structnew() /> > > <cfset aCustomColumns[2].title = "Author 2"/> > > <cfset aCustomColumns[2].webskin = "displayAuthor2" /> > > > <ft:objectAdmin > > title="Article management" > > typename="ctArticle" > > ColumnList="title,publishDate,secArticle,priority,bCommented,status" > > SortableColumns="title,publishDate,bCommented,status" > > lFilterFields="title,publishDate" > > qRecordSet="#latestArticles#" > > stFilterMetaData="#stFilterMetaData#" > > acustomColumns="#aCustomColumns#"/> > > > But if i remove my query along with qRecordSet in ft:objectAdmin > > everything will work fine. > > > Any ideas? > > > Thanks, > > Mika > > > -- > > 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 -- 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
