Error: List Type isn't pulldown

4 posts by 2 authors in: Forums > CMS Builder
Last Post: June 18, 2009   (RSS)

By isdoo - June 17, 2009

Hi,

Using 1.29.

When I go to upload a news item, I am presented with the error of 'List Type isn't pulldown'.

This is on a field named 'league', within a table called news1, this is set to:

Field label: Team
Field Name: team
Field Type: List
Display as: pulldown
List Options: use Options Listed below (then I have a dozen or so entries all in for the form of asas_shjs|asas shjs etc...

I also have a field named 'team' - this is set to

Field label: Team
Field Name: team
Field Type: List
Display as: Checkboxes (Multi value)
List Options: Advanced MySQL
SELECT team, team FROM cms_teams WHERE league = '<?php echo $ESCAPED_FILTER_VALUE ?>'
Advanced Filter: Refresh list when this field changes: league

I have a separate table created called teams where I currently have to fields league & team

League list league
Team textbox team

The league is identical to the league in the news1 table, and the list of teams is a simple text box. As a result I have a database with unique club names and their current leagues.

I am not sure what is creating this error.

Thanks in advanced.

Re: [isdoo] Error: List Type isn't pulldown

By ross - June 18, 2009

Hi Ian

Thanks for sending me your details!

I had a look and the problem turned out to be that your second field was set as checkboxes. To use this particular feature, your second field (the one that changes) needs to be set as a pulldown list.

I changed it for you so you should be able to try it out again.

Let me know what you think ;).
-----------------------------------------------------------
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] Error: List Type isn't pulldown

By isdoo - June 18, 2009

Many thanks Ross. Slowly getting to grips with CMS Builder :)