Show detail record only from the archive list

7 posts by 3 authors in: Forums > CMS Builder
Last Post: January 8, 2015   (RSS)

By MercerDesign - January 5, 2015

Hi, I have a multi list setup so that there are current courses and previous courses and am using the combo code so the list and detail is on the same page. It all works fine but on the archive page I want to show the first article from the arhive list but if I put to show the first record it shows the first record in the whole list, how can I do it so that it will show the detail from the first archive article? The links to see what I mean are: http://www.twentyfifty.co.uk/2050-training.php and http://www.twentyfifty.co.uk/training-archives/2050-training.php

By gkornbluth - January 5, 2015

Hi,

Just a guess, but if you repeat the load records call just before the code that uses it, you can change the parameters fro each group of records.

Hope it helps,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By MercerDesign - January 6, 2015

Sorry, I'm not sure what you mean. I just need to tell the archive page to just show archive detail records and not pull in ones that are ticked as current. Thanks

By claire - January 6, 2015

Hey Mercer

What you want to do is use the same getRecords call but add an additional parameter to the where clause to filter out records that are ticked as current. Do you know how to do that? If not, attach your code here and I'll take a look.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By MercerDesign - January 7, 2015

Hi, I already have the list displaying correctly but it is the detail record that I cannot get to show correctly. I just need to show hte detail record that applies to the first archive record in the list but cannot get that to work. Thanks for your response though.

By claire - January 8, 2015

Hi Mercer, can you please attach the code for your viewer file here?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/