nuBuilder Forum

Hi,

How can i display select 2 multiselect data. At the moment it displays in array format eg.

i want it to display as 0,1 etc only. How can this be achieved?

Hi,

How many distinct values are there? Are they stored a list 0|something|1|something2 or retrieved by SQL from another table?

kev1n wrote: ↑Fri Feb 25, 2022 8:20 am Hi,

How many distinct values are there? Are they stored a list 0|something|1|something2 or retrieved by SQL from another table?

At the moment two values and its a stored list

If it's just 2 values, do a replace

E.g.

kev1n wrote: ↑Fri Feb 25, 2022 9:14 am If it's just 2 values, do a replace

E.g.

Code: Select all

REPLACE(REPLACE(your_column,'1','something'),'2','something else')

How is it achievable if there are more than 2 values

If the values are stored in an other table:

viewtopic.php?p=16613

kev1n wrote: ↑Fri Feb 25, 2022 9:17 am If the values are stored in an other table:

viewtopic.php?p=16613

Thanks for your quick response, i will try your suggestions and let you know how it goes.

Thanks Kevin

Thanks, Kevin, Both the suggestions worked well. Best Regards.