MySQL Column Type

4 posts by 2 authors in: Forums > CMS Builder
Last Post: April 14, 2014   (RSS)

By ht1080z - April 10, 2014 - edited: April 12, 2014

Hi,

I have a table with ~16000 record and in this table a field that i want to use the "get option from database (advanced)" list option with related data from another field.

When the related record "num" is bigger than 999, i cannot see anymore the selected "title" label but only the record num that cannot be associated with the label. Of course the records with this unchained record nums are exists. Please see attached screenshots for details.

I presume this problem is somehow related to the MySQL column type and the way data is stored in the db.

How can i fix this issue?

PS: new screenshot (table_5.jpg attached)

Please advise,
Karls

By ht1080z - April 12, 2014

Hi Chris,

Thank you for the fix, worked perfectly!

Karls

By Chris - April 14, 2014

Hi Karls,

Glad to hear it! :)

All the best,
Chris