Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (31:3) to (31:47).
codingnya :
<cfquery datasource="customer" name="update">
UPDATE custmast
SET custname ='#FORM.fcustname#',
email='#FORM.femail#',
sex='#FORM.fsex#',
citynum=#FORM.fcitynum#,
desc= '#FORM.fdesc#'
WHERE custnum = #FORM.fcustnum#
</cfquery>
catatan : untuk number hanya di citynum ama custnum, lainnya text, desc type nya memo.
kok error terus seh ?
help
;p in
