----- Original Message -----
From: Ineke <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 19, 2000 1:35 PM
Subject: [MasterWeb] sql
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#', --- kelupaan '' nya kali yah ?
desc= '#FORM.fdesc#'
WHERE custnum = '#FORM.fcustnum#' ---ini juga
</cfquery>
catatan : untuk number hanya di citynum ama custnum, lainnya text, desc type nya memo.
kok error terus seh ?
help
;p in
