Why not use a dmhtml webskin that grabs the currently assigned category, then list any news items that match it? This is relatively straightforward. You should also be using getcontentobjects() rather than your own queries - it's just a lot simpler.
GB On Monday, February 18, 2013, Marco van den Oever wrote: > I created the 26 categories html pages by the quick site builder, manually > creating 26 webskins seems a lot of work :( > But i can't believe this is not possible without creating webskins, it > must be possible to create a link to the right category html object based > on the dmnews item catid, even when there are duplicate title's in the > dhtml table... > > Thanks! > > Op zondag 17 februari 2013 15:40:36 UTC+1 schreef Sean Coyne het volgende: > > Instead of creating an HTML page and trying to match it, just create > webskins for the category and link directly to that. > > On Saturday, February 16, 2013 4:48:45 PM UTC-5, Marco van den Oever wrote: > > Hi Sean thanks for answering, as you see now i match through the label > value "WHERE label = '#category.categoryLabel#'" so because there are 2 > of the same label values there i get the wrong (first) objectid value. > > <!--- get news category ---> > <cfquery name="category" datasource="aquariusagenieuw"> > SELECT categoryLabel > FROM dmcategory > WHERE ObjectID = '#stObj.catNews#' > </cfquery> > > <!--- get category dmhtml objectid---> > <cfquery name="dmhtmlobjectid" datasource="aquariusagenieuw"> > SELECT ObjectID > FROM dmhtml > WHERE label = '#category.categoryLabel#' > </cfquery> > > <skin:buildLink objectid="#dmhtmlobjectid.**ObjectID#" title="#category. > **categoryLabel#">#category.**categoryLabel#</skin:**buildLink> > > So what's the right way? I assume this isn't :) > > Thanks. > > Op zaterdag 16 februari 2013 21:22:45 UTC+1 schreef Sean Coyne het > volgende: > > Can you create a Gist or Pastebin of the code you are using? > > On Friday, February 15, 2013 7:59:07 PM UTC-5, Marco van den Oever wrote: > > Hi all, i have a problem... > > I have created categories for my news categories and also link categories, > so i used the same categories for news and links. > I also created dmhtml objects for news and links categories, so in dmhtml > i have 2 of the same title's for every category. > > Now i want to display a category link on the dmnews item's page, that > refers to the dhtml object that it belongs to. > > If i use the buildlink tag and fill in the stObj.catNews value of the news > item i get a: > > "key [TITLE] doesn't exist in struct" > > Am i doing something wrong? > > Thanks. > > -- > 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 because you are subscribed to the Google Groups > "farcry-dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to -- 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 because you are subscribed to the Google Groups "farcry-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
