Like the old implode/explode functions in PHP? example: id="something[]"

Hello Bobby,
What do you need to achieve - to store the selected values as a comma separated list in a single database field?

Yes. That's exactly right.

Just like I can using PHP/MYSQL:

<select name="a_set_of_values[]" multiple  id="a_set_of_values">
                <option value="Value_1">Value_1</option>
                <option value="Value_2">Value_2</option>
                <option value="Value_3">Value_3</option>
                <option value="Value_4">Value_4</option>
                <option value="Value_5">Value_5</option>
                </select>

$Valuestochoose = implode(',',$_POST[a_set_of_values]);

$sql = "INSERT INTO a_table (some_field) VALUES ('$Valuestochoose)";

I need to do the exact same thing with DataBindings, but can't figure it out.

But selecting {{$_POST.a_set_of_values}} as a value in the insert record step, should do exactly this.

I thought that too, but when I add the brackets [] to the select name, the form doesn't add the data at all and it doesn't throw an error.

This is extremely frustrating.

Please provide a link to your page where i can check the issue.

Hello Teodor,

I've created a sample page with 2 forms. One is the PHP version and scripting that works, and the other is setup using DMX Data Binding.

The PHP form allows you to multi-select and it creates a comma separated array and places those values into a field in the database.

The DMX Data Bindings form only inputs the last selection made. It does not create the array that I need.

Your help is greatly appreciated.

-Bobby

Sample Link:
faces.vegas/DMX_DB_HELP.php

But your DMXzone example's select does not have [] in the name:

        <select name="dmx_sample" multiple id="dmx_sample">

It must be:

        <select name="dmx_sample[]" multiple id="dmx_sample">

Like I said before, when I add those brackets, the form doesn't add anything to the field. I made that change in an example to show you what I mean.

No Brackets: faces.vegas/DMX_DB_HELP.php

With Brackets: faces.vegas/DMX_DB_HELP_with_brackets.php

That is why i wanted to check ...
Please:
1. Remove the go to url behavior, on complete
2. Enable debug mode in server connect so i can see the exact error message

I've done as you said.

faces.vegas/DMX_DB_HELP_with_brackets_debug.php

Hi Bobby,
I tested that, and this kind of insert requires the use of server data formatter. You need to add this, as an insert value: {{$_POST.a_set_of_values.join(",", null)}}

Perfect! Thank You, Teodor.