Of course, and that is perfect but i want it to work out of the box :) On Aug 6, 2:30 pm, Sean Coyne <[email protected]> wrote: > You can just write your own execute.cfm for the ruleNews rule and then > you can have it list whatever news items you like. > > Thats the beauty of FarCry's webskin inheritance. > > Sean > > On Aug 6, 5:39 am, Marco van den Oever <[email protected]> > wrote: > > > So Sean you where right it's all about the publish date not being set, > > that's the issue, for now i will just go and generate all old articles > > in the dmNews table, don't have to update those articles anyway soon, > > then if neccesary for specific article i can update individual. Not a > > best solution but can get going now... > > > On Aug 6, 10:49 am, Marco van den Oever <[email protected]> > > wrote: > > > > Ah ok perfect, only when i use the BER version 018 and FC 6.0.3 i have > > > some other errors. > > > > I can click overview and site tabs but content and admin tabs give > > > error like: > > > > Message The parent argument must be a webtop struct or an id path > > > specifying an existing webtop struct > > > Exception Type application > > > > * C:\websites\Farcry\core\packages\farcry\webtop.cfc (line: 334) > > > * C:\websites\Farcry\core\tags\admin\subSectionOverview.cfm (line: 51) > > > * C:\websites\Farcry\core\webtop\custom\content.cfm (line: 9) > > > > On Aug 6, 4:34 am, AJ Mercer <[email protected]> wrote: > > > > > I have posted about missing dates for news and events when using Railo > > > > One of the BER patches fixes that issue. > > > > > All 3.1.2 (BER) patches will be rolled up and released as Railo 3.2 > > > > > On 6 August 2010 02:51, Marco van den Oever > > > > <[email protected]>wrote: > > > > > > I think i have found the problem. > > > > > > I am on FC 6.0.3 and Railo 3.1.2.001 and when i select an publish or > > > > > expiry date it isn't filled in the database. > > > > > > That's why my migration script worked as i set those values manually. > > > > > > On Aug 5, 8:29 pm, Marco van den Oever <[email protected]> > > > > > wrote: > > > > > > I have added a news item through the webtop, i see that everything > > > > > > is > > > > > > added ok. > > > > > > Then i added a news rule that have to display the news item based on > > > > > > the category. > > > > > > In the refcategories table there is a record created for the > > > > > > newsrule > > > > > > but it's not displayed on the page. > > > > > > > The strange thing is that when i add a news item through the > > > > > > automated > > > > > > code, the migration script i use to add all old articles into > > > > > > dmNews, > > > > > > it is working... > > > > > > > Any idea's? > > > > > > > On Aug 5, 1:14 pm, Marco van den Oever <[email protected]> > > > > > > wrote: > > > > > > > > Ah stupid mistake, was missing a /> at a below code... thanks. > > > > > > > I tested the code and all is now working fine, the articles are > > > > > > > shown, > > > > > > > thanks all that helped out! > > > > > > > > On Aug 4, 10:09 pm, Sean Coyne <[email protected]> wrote: > > > > > > > > > Actually you have a space in your call: > > > > > > > > > qNews.cat News > > > > > > > > > should be > > > > > > > > > qNews.catNews > > > > > > > > > Sean > > > > > > > > > On Aug 4, 4:08 pm, Sean Coyne <[email protected]> wrote: > > > > > > > > > > Syntax error usually means you have a stray # or another typo > > > > > > > > > somewhere. Check your code for proper CFML syntax. > > > > > > > > > > On Aug 4, 3:36 pm, Marco van den Oever > > > > > > > > > <[email protected] > > > > > > > > > > wrote: > > > > > > > > > > > And the error is "Syntax Error, Invalid Construct" > > > > > > > > > > > On Aug 4, 9:34 pm, Marco van den Oever < > > > > > [email protected]> > > > > > > > > > > wrote: > > > > > > > > > > > > Ok almost there.. only thing is i get an error about the > > > > > > > > > > > code: > > > > > > > > > > > > <cfset > > > > > > objCategory.assignCategories(objectid=qNews.objectid,lCategoryIDs=qNews.cat > > > > > News)> > > > > > > > > > > > > On Aug 4, 9:00 pm, Chris Kent <[email protected]> wrote: > > > > > > > > > > > > > Yep - that should do it. have just done this importing > > > > > content fro a > > > > > > > > > > > > V4 site to V6. > > > > > > > > > > > > > Just make sure you use the same stProps structure as > > > > > > > > > > > > this > > > > > will have > > > > > > > > > > > > the content item objectid and cat ids (should be > > > > > > > > > > > > catNews for > > > > > dmNews) > > > > > > > > > > > > > if you have already imported the content, then > > > > > > > > > > > > something like > > > > > the > > > > > > > > > > > > following (untested) code shoudl run through the new > > > > > > > > > > > > items > > > > > and assign > > > > > > > > > > > > teh categories. > > > > > > > > > > > > <cfset objCategory = > > > > > > CreateObject("component","#application.packagepath#.farcry.category") > > > > > / > > > > > > > > > > > > > <cfset qNews = > > > > > application.fapi.getContentObjects(typename="dmNews", > > > > > > > > > > > > lProperties="objectID,catNews") /> > > > > > > > > > > > > <cfloop query="qNews"> > > > > > > > > > > > > <cfset > > > > > > objCategory.assignCategories(objectid=qNews.objectid,lCategoryIDs=qNews.cat > > > > > News)> > > > > > > > > > > > > </cfloop> > > > > > > > > > > > > > Chris. > > > > > > > > > > > > > On 4 Aug, 19:38, Marco van den Oever < > > > > > [email protected]> > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > Mmm still have to follow your example of the > > > > > refCategories.. I assume > > > > > > > > > > > > > that is for each item, dmNews, dmImage, that have a > > > > > category assigned? > > > > > > > > > > > > > > so after the setData just insert: > > > > > > > > > > > > > > <cfset objCategory = > > > > > > CreateObject("component","#application.packagepath#.farcry.category") > > > > > / > > > > > > > > > > > > > <cfset > > > > > > objCategory.assignCategories(objectid=stProps.objectid,lCategoryIDs=stProps > > > > > .catNews)> > > > > > > > > > > > > > > ? > > > > > > > > > > > > > > On Aug 4, 8:24 pm, Marco van den Oever < > > > > > [email protected]> > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > Mmmm found the problem for this one, i used > > > > > > > > > > > > > > "createData" > > > > > instead of > > > > > > > > > > > > > > "setData", now that i use "setData" it works... > > > > > > > > > > > > > > thanks > > > > > man for helping > > > > > > > > > > > > > > out. > > > > > > > > > > > > > > > On Aug 4, 8:22 pm, Chris Kent <[email protected]> > > > > > wrote: > > > > > > > > > > > > > > > > refcategories > > > > > > > > > > > > > > > > Chris > > > > > > > > > > > > > > > > On 4 Aug, 18:59, Marco van den Oever < > > > > > [email protected]> > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > Are those relations stored in a table, and > > > > > > > > > > > > > > > > where? I > > > > > indeed must be > > > > > > > > > > > > > > > > missing something then... > > > > > > > > > > > > > > > > > On Aug 4, 4:24 pm, Chris Kent > > > > > > > > > > > > > > > > <[email protected]> > > > > > wrote: > > > > > > > > > > > > > > > > > > Marco, > > > > > > > > > > > > > > > > > > Do I remember that you have been importing > > > > > > > > > > > > > > > > > content? > > > > > > > > > > > > > > > > > > If so, did you assignCategories(...) after > > > > > > > > > > > > > > > > > each > > > > > setData(...)? This is > > > > > > > > > > > > > > > > > required to assign the categories to the > > > > > > > > > > > > > > > > > content > > > > > item. > > > > > > > > > > > > > > > > > > e..g for each content item you woudl be doing > > > > > somehting like > > > > > > > > > > > > > > > > > <cfset > > > > > application.fapi.setData(stProperties=stProps) /> > > > > > > > > > > > > > > > > > > you also need to do > > > > > > > > > > > > > > > > > <cfset objCategory = > > > > > > CreateObject("component","#application.packagepath#.farcry.category") > > > > > / > > > > > > > > > > > > > > > > > > <cfset > > > > > > objCategory.assignCategories(objectid=stProps.objectid,lCategoryIDs=stProps > > > > > .catNews)> > > > > > > > > > > > > > > > > > > Chris. > > > > > > > > > > > > > > > > > > On 4 Aug, 14:58, Marco van den Oever < > > > > > [email protected]> > > > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > Filled in a publish date, also removed all > > > > > > > > > > > > > > > > > > null > > > > > values to make sure > > > > > > > > > > > > > > > > > > railo wasn't having any problems from that, > > > > > > > > > > > > > > > > > > but > > > > > no change. > > > > > > > > > > > > > > > > > > > The issue has something to do with > > > > > > > > > > > > > > > > > > categories. > > > > > There is something > > > > > > > > > > > > > > > > > > going on there with FC6.0.3 and Railo > > > > > > > > > > > > > > > > > > 3.1.2.001. > > > > > > > > > > > > > > > > > > > As soon as i create categories the problem > > > > > > > > > > > > > > > > > > is > > > > > occurring... > > > > > > > > > > > > > > > > > > > On Aug 4, 1:42 pm, Sean Coyne < > > > > > [email protected]> wrote: > > > > > > > > > > > > > > > > > > > > What database are you on?? > > > > > > > > > > > > > > > > > > > > I have found issues w/ the > > > > > > > > > > > > > > > > > > > "getContentObjects" > > > > > method on Railo and > > > > > > > > > > > > > > > > > > > MySQL because of the "null" dates that > > > > > > > > > > > > > > > > > > > FarCry > > > > > uses (Jan 1 1970, if I > > > > > > > > > > > > > > > > > > > remember correctly). I never had a > > > > > > > > > > > > > > > > > > > chance to > > > > > investigate and raise a > > > > > > > > > > > > > > > > > > > bug. > > > > > > > > > > > > > > > > > > > > Do you have a publish date set on the news > > > > > item? > > > > > > > > > > > > > > > > > > > > The category filter uses the following > > > > > > > > > > > > > > > > > > > query > > > > > which REQUIRES that you > > > > > > > > > > > > > > > > > > > have a valid date for a publish date. > > > > > > > > > > > > > > > > > > > NULL is > > > > > not OK. Notice below > > > > > > > > > > > > > > > > > > > how it allows for expiry date to be null, > > > > > > > > > > > > > > > > > > > but > > > > > not the publish date. > > > > > > > > > > > > > > > > > > > > <cfset oCat = createObject("component", > > > > > > > > > > > > > > > > > > > "farcry.core.packages.types.category") /> > > > > > > > > > > > > > > > > > > > <cfset q = > > > > > oCat.getDataQuery(lCategoryIDs="#stObj.metadata#" > > > > > > > > > > > > > > > > > > > ,typename="dmNews" > > > > > > > > > > > > > > > > > > > ,maxRows="#maximumRows#" > > > > > > ,bMatchAll="#stobj.bMatchAllKeywords#" > > > > > > > > > > > > > > > > > > > ,sqlWhere="publishdate <= > > > > > #now()# AND (expirydate >= #now()# OR > > ... > > read more »
-- 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
