SQL Formatting an Array

Developer Talk
1

Hi everyone, I feel like i’m biting my teeth out on this one.
I’m trying to update a multi-select field with SQL but this formatting:

UPDATE Talente SET beruflicheKenntnisse='["Microsoft Office","SAP"]' WHERE E-Mail = '{email}'

only gets me this error:
{‘error_message’: ‘failed to convert value: invalid value’}
Same with any other multi-select field. The values are definitely correct.
Is my formatting just wrong?

2

Hi
Updating values in multiple select, please use parentheses instead of brackets. The SQL should be somehow like:

UPDATE Talente SET beruflicheKenntnisse=("Microsoft Office","SAP") WHERE ....

Please try again

1 Like
3

Yes that was it.
Thanks!

4

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.