I have an integer field in my mysql database called org_spec_use. On my form, it is defined as a double select and I do a lookup from another table.
If I add more than 1 item to this field and SAVE,
I end up with code like :
UPDATE organization SET org_type = 4, org_name = ‘Test Org’, org_spec_use = 2;3;1 WHERE org_key = 1
So, when the code is executed, everything past the semi colon is ignored, including the WHERE. How do I fix this? Enclose the 2;3;1 in quotes? [HR][/HR]