Creating a list page with information from 2 multi record editors

5 posts by 3 authors in: Forums > CMS Builder
Last Post: June 1, 2009   (RSS)

Re: [gkornbluth] Creating a list page with information from 2 multi record editors

By ross - May 26, 2009

Hi Jerry

Thanks for posting!

I think I am going to need a better idea of how you have everything setup.

It sounds like you are actually dealing with three sections. Events, Exhibits and Opening Receptions.

From there, I think each event has a bunch of events but only one opening reception. You have all the event's main details right in the event table. Each exhibit is assigned to a specific event by the title of the event (which you do with a multi select menu). The same thing happens with the Opening Receptions.

Does that sound about right? Let me know if I am on the right track and we'll go from there.

Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [ross] Creating a list page with information from 2 multi record editors

By gkornbluth - May 26, 2009 - edited: May 29, 2009

Ross,

Thanks for looking at this.

There are actually only 2 multi record editors:

1) “Exhibitions” that contains the basic information about each exhibition and

“Opening Receptions”that contains the date and time of the opening reception for each exhibition (if any)

Both editors have a field called “exhibition” that contains the name of the exhibition.

I separated the exhibition information from the reception information so that I could automatically “hide” the reception information after the reception date has passed.

As you can see from http://www.lkmix.com/index3.php the exhibition information is displaying correctly, (there are only 2 exhibition records) but instead of the “where” statement limiting the reception date information to that belonging to the specific exhibition, all reception dates show in all of the listings.

I know that I must be doing something pretty lame, but I can’t seem to find what it is.

Jerry
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

Re: [ross] Creating a list page with information from 2 multi record editors

By gkornbluth - May 29, 2009

Hi Ross,

If you have a moment that either you or someone can revisit this, I'd be grateful.

Thanks,

Jerry
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

Re: [gkornbluth] Creating a list page with information from 2 multi record editors

By Dave - June 1, 2009 - edited: June 1, 2009

Hi Jerry,

Can you email me CMS and FTP login details to dave@interactivetools.com so I can take a look at the setup? That will be the quickest way for me to determine the issue. Note: Email, don't post login details to the forum.

Also, please include a link to this post.

Thanks, hope that helps!
Dave Edis - Senior Developer
interactivetools.com