Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder: Plugins & Add-ons:
GeoPlugin - Relational Data

 
 


Illume Magazine
User

May 24, 2011, 3:51 PM

Post #1 of 4 (287 views)
Shortcut
GeoPlugin - Relational Data Can't Post
Hi,

I wanted to know how to create relational fields in the backend section? Basically, I have created a section for restaurant listings and have acquired a db of all zip/city/states in the U. S.

I want to make it easy on my editors to add entries in the system.

For example, when adding an entry, if the zip code is added first, cmsb would auto populate the city & state fields (in dropdowns), or when a state is selected in a drop down, the next drop down would automatically narrow in on the cities only in that state, and once a city is selected, the zip drop down would only show the zip codes for that particular city.

Any help would be appreciated.

Regards,

Javed Ali.


Jason
Staff / Moderator


May 25, 2011, 10:26 AM

Post #2 of 4 (276 views)
Shortcut
Re: [Illume Magazine] GeoPlugin - Relational Data [In reply to] Can't Post
Hi,

Depending on how you are storing your information, you should be able to accomplish this using drop downs and the "Advanced Filter" option.

Take a look at this post:
http://www.interactivetools.com/forum/gforum.cgi?post=83755#83755

Hope this helps get you started.
---------------------------------------------------
Jason Sauchuk - Programmer 
interactivetools.com

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


Illume Magazine
User

May 26, 2011, 10:08 AM

Post #3 of 4 (271 views)
Shortcut
Re: [Jason] GeoPlugin - Relational Data [In reply to] Can't Post
So I think it looks like extensive code in the advance query. Alot of ifs..

I thought there might be an easier way to build relational lists.


Jason
Staff / Moderator


May 26, 2011, 1:08 PM

Post #4 of 4 (267 views)
Shortcut
Re: [Illume Magazine] GeoPlugin - Relational Data [In reply to] Can't Post
Hi,

You don't need to use any if statements. You just need to put in your mysql query and choose your advanced filter field. Unfortunately, there isn't an easier way of accomplishing this in CMS Builder.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Programmer 
interactivetools.com

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