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 > > > > > > > > > > > > > > > > > > expirydate is NULL)" > > > > > > > > > > > > > > > > > > ,sqlOrderBy="publishDate > > > > > > > > > > > > > > > > > > DESC" > > > > > > > > > > > > > > > > > > ) /> > > > > > > > > > > > > > > > > > > > On Aug 4, 5:26 am, Marco van den Oever < > > > > [email protected]> > > > > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > > still have the same problems, don't think > > > > this resolve my issues. > > > > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > > > On Aug 4, 11:24 am, Marco van den Oever < > > ... > > 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
