This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Web designer - Multiselect

Hi Experts,

I know the IT shop can show a drop-down list of limited values. Can it also show a multi-selectable drop down list of limited values? The use-case is that we have a list of value (separated by char(7) in a custom table, and this list should be shown as a drop down in the IT shop where the user can select multiple values frmo this list)

IF so, which web designer component should be used to display such a list? (I'm not a web designer but I have been asked to ask this question to pass to our web designer)

v7.1.1

0 Robert Byrne over 7 years ago

Hi,

I think the VI_Edit_MultiLimitedValues object would be a good start?

hth,

Rob.
Cancel
Up 0 Down

Cancel
0 kinshasa over 7 years ago

Thanks Rob, our WD said that module didn't help, so he has made his own one. He did ask me to check something: Is it possible to combine multiple values into a char(7) separeated string in Web Designer? There is a collection with just one column, lets say it 3 rows with values "Apple", "Oranges", "Pears" - what he wants is to return one string containing "Apple,Oranges,Pears" (separated by char(7) instead of ,)

Is this possible using WebSQL?
Cancel
Up 0 Down

Cancel
+1 Hanno Bunjes over 7 years ago

Hi,

Yes, this is possible using the concat function. Example:

Concat(select firstname from person, ", ")

HTH

Hanno
Cancel
Up 0 Down

Cancel
0 kinshasa over 7 years ago

Thanks Hanno, worked as you said it would.
Cancel
Up 0 Down

Cancel