Hopefully someone can help me with this issue I'm having.
I'm trying to save the values of multiple selected checkboxes into one field separated by commas through ADDT's Insert Transaction code. I can do this easily with DW's standard insert record wizard by using the PHP implode() function but I haven't been able to figure it out with ADDT's code.
<form> <input type="checkbox" value="1" name="program" /> Program One <input type="checkbox" value="2" name="program" /> Program Two <input type="checkbox" value="3" name="program" /> Program Three <input type="checkbox" value="4" name="program" /> Program Four </form> THIS IS ADDT'S CODING $ins_quoteManager->addColumn("programs", "STRING_TYPE", "POST", "programs"); THIS WORKS VIA DREAMWEAVER'S INSERT RECORD WIZARD Original: GetSQLValueString($_POST['programs'], "text"), Modified: GetSQLValueString(implode(',',$_POST['programs']), "text"),
Anyone know how to modify the ADDT code with the implode function to get this to work?
Have you tried ADDT´s "comma-separated checkboxes" form control, which will also store the values into a field of your choice (and of course retrieve them from there on update record - pages) ? The only possible drawback might be, that the checkboxes can´t be defined statically, means that the array of value/label - pairs will be retrieved from another table by establishing an additional recordset.
I did realize the comma-separated checkbox option after I posted but was still hoping to see if their was another way.
If not I guess I'll have to make due. Thanks!