Sql query failed for special char "-"

Getting Help
1

I am using [sqlx] general purpose extensions to golang’s database/sql

I am facing UPDATE sql query failure for special char “-” in following code,

userData := “55cac6cc-c13f-4bfd-9d20”
…
queryUpdateUser := "UPDATE Users As u SET u.modified_by=?, u.modified_at=? WHERE u.uid=? AND u.userData IN (?)

query, args, errSql := sqlx.In(queryUpdateUser, modby, modat, usrID, userData )
query = dc.Store.DB.Rebind(query)

_, err := tx.Exec(query, args…) //This statement failed

Error 1054: Unknown column ‘55cac6cc’ in ‘where clause’\n" x-hptm-transaction-id=

Please let me know if any other way to resolve this issue?

2

What does query look like after sqlx.In runs?

3

Its same…
query = UPDATE Users As u SET u.modified_by=?, u.modified_at=? WHERE u.uid=? AND u.userData IN (?)

4

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