Limited

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

By Joseph - June 5, 2013

Hi

I shall try and explain this as best as I can.

I have created a section in CMSB called Images where i have uploaded close to 1050 images. I have alsoe created a section called News and within news i have created a drop down menu called Images which allows the user to select from the images section. My problem now is the Drop down image list in News will only display the first 1,000 images and any news article accessing an image that migt be image no.1035 comes up with a number and not the image name in fact it says the image name is missing.

how can i adjust the drop down menu within the news section to display more than 1,000 images?

By Daryl - June 5, 2013

Hi Joseph,

You can display more than 1000 options in a drop down list field by setting the "List Options" in the Field Editor of your drop down field to "Get options from MySQL Query" and set a LIMIT in the MySQL query in the text area below.

For example:

SELECT num, image_name
FROM `<?php echo $TABLE_PREFIX ?>images` LIMIT 1100

Let us know if you have any more questions.

Thanks,

Daryl

Daryl Maximo
PHP Programmer - interactivetools.com

By Daryl - June 5, 2013

Would you mind filling up a 2nd level support request form so we can take a closer look?

The form can be found here: https://www.interactivetools.com/support/email_support_form.php

Thanks!

Daryl

Daryl Maximo
PHP Programmer - interactivetools.com