On Jul 8, 6:18 am, "Dan T.W." <[EMAIL PROTECTED]> wrote: >> But now my users won't be able to filter on content. Can someone tell >> me why it's been working fine for months then suddenly behaves this >> way? > > It's not an error I've seen. But it sounds like the system is getting > something unexpected from the database or alternatively applying the > filter there is something wrong with something like the casting of > certain values.
I'd suggest something has changed ;) Rarely do things suddenly happen with no reason. Can you send through the code for the dmCPAJ content type -- specifically the cfproperty tags. Can you tell from your version control system if this file has changed at all in recent times? Just shooting the breeze here... stack traces are tough to decipher but it looks like you are running the getDefaultObject() function (which may be linked to creating a faux object for the filter), and then blowing a gasket on a month() function. Need to confirm that your formtool metadata is generating valid default content -- especially date content. If the content type can be cleanly deployed and then doesn't generate the error you are experiencing then i'd suggest its a data issue -- how many records in this table? What database are you using? >> qgetData (Datasource=farcry, Time=15ms, Records=0) in E:\farcry\core >> \packages\fourq\_fourq\getData.cfm @ 16:26:21.021 >> SELECT >> title,coAuthor,teaserImage,thirdAuthor,displayMethod,publishDate,datetimecr >> eated,vol,expiryDate,status,mainPage,commentlog,Teaser,createdby,publisher >> Letter,Body,datetimelastupdated,ownedby,label,num,catContents,subTitle,fea >> ture,versionID,author,lastupdatedby,ObjectID,locked,lockedBy >> FROM DBO.dmCPAJ >> WHERE ObjectID = 'E5744CF4-1A4B-F8A3-945594B8574C9658' > >> The thing is, it's supposed to be a custom admin for listing content >> objects. Why FarCry was looking for an unexisting object in my content >> table? This is a standard getData() call. If it returns 0 records it will generate an empty struct. This is unlikely to be your issue. >> Are you saying that this query returns no result if you run it in >> isolation in a query tool? > > Yes, I looked for that objectId in both my content table and the > refObjects table. It's not there. Actually the objectId has not been > unique. After a while, it returned a different but still unexisting > objectId. The filter form essentially creates a "dummy" object for the formtools engine to act on. So its not unusual to have in-memory only objects that are not represented in the database. -- geoff http://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
