ajax - 使用 AJAX 表达 PATCH 请求:“(”或附近的语法错误
问题描述
我正在尝试使用带有 AJAX 的 PATCH 请求编辑表中的条目,但是我收到以下错误:
error: syntax error at or near "("
at Connection.parseE (...\node_modules\pg\lib\connection.js:553:11)
at Connection.parseMessage (...\node_modules\pg\lib\connection.js:378:19)
at TLSSocket.<anonymous> (...\node_modules\pg\lib\connection.js:119:22)
at emitOne (events.js:116:13)`enter code here`
at TLSSocket.emit (events.js:211:7)
at addChunk (_stream_readable.js:263:12)
at readableAddChunk (_stream_readable.js:250:11)
at TLSSocket.Readable.push (_stream_readable.js:208:10)
at TLSWrap.onread (net.js:597:20)
我相信我已经本地化了这个问题。我正在使用 PostgreSQL 语法检查器,它说:
Error(s), warning(s):
42601: syntax error at or near "("
这是查询:
UPDATE characters SET COALESCE($1, name), COALESCE($2, role), COALESCE($3, age), COALESCE($4, gender), COALESCE($5, race), COALESCE($6, nationality) WHERE id=$7;
查询是问题吗?如果没有,你建议我做什么来解决这个问题?