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.
When I select multiple items from the lookup and “Save”, I end up with a sql statement like :
(pdo-mysql): UPDATE organization SET org_type = 4, org_name = ‘Test Org’, org_spec_use = 2;3;1 WHERE org_key = 1
So the semi colon between the values of org_spec_use ends the sql statement and the “Where” clause is skipped. How do I fix this? Thanks.