Update multiple select list

I'm able to insert multiple values from a select list, but I can't get the select list to show the stored values on an update record page. I have a set of square brackets added to the name of my field to indicate an array, but it doesn't seem to help. What am I doing wrong?

- Joe

on the insert page, is it inserting the multiple values as a comma separated list to the database?


can you send a copy of the insert and update pages so i can examine the code

Actually, I'm using DataAssist's Manage Relational Table server behavior to write to a related table. You'll also notice that I'm using a jQuery plug-in (bsmSelect) to display the multiple select lists better. Even if I expand the select list to a height of 10 or so, my update list shows all entries selected.

I've attached the basic files - let me know if you want to see the files work online or anything else.

Thanks - Joe

Go to the bindings panel, and click the plus button, select URL Variable and name it id.

in the manage relational table behavior on the update page, set the master key value to use the id URL Variable.

Tried that, Jason, but I'm still getting all the entries in the multi-select list chosen. Any other thoughts?

change the code for the options:

<option value="<?php echo $row_rsFaculty['id']?>"<?php if (!(strcmp($row_rsFaculty['id'], $row_rsFaculty['id']))) {echo "selected=\"selected\"";} ?> <?php if (!(strcmp($row_rsFaculty['id'], WA_AB_returnPreSelectValue($WA_PreSelect_RelationalTable_1, $row_rsFaculty['id'])))) {echo "selected=\"selected\"";} ?> ><?php echo $row_rsFaculty['theName']?></option>

to:

<option value="<?php echo $row_rsFaculty['id']?>" <?php if (!(strcmp($row_rsFaculty['id'], WA_AB_returnPreSelectValue($WA_PreSelect_RelationalTable_1, $row_rsFaculty['id'])))) {echo "selected=\"selected\"";} ?> ><?php echo $row_rsFaculty['theName']?></option>