CFUPDATE SCRIPT !! PLEASE HELP

[kingjjx]

Hi, I am trying to write a ColdFusion update script.
I have successfully wrote the page that ads data to the databaase but everytime i make changes and click on submit, it gives me this error message: (MY SCRIPT IS BELOW)

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near 'YEHS'.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (7:1) to (7:51).

**********************************************
MY SCRIPT LOOKS LIKE THIS :
RUNDATA IS THE TABLE NAME
DYNORUNEX IS THE DATABASE NAME

<CFQUERY NAME=&quot;EditDynorun&quot; DATASOURCE=&quot;DynoRunEX&quot;>

UPDATE RunData SET Model='#Model#','#mAKE#' ETC .. ETC .. WHERE PriKey=#PriKey#
</CFQUERY>


WHAT IS WRONG WITH THIS SCRIPT ??? PLEASE HELP ?
THANK YOU

 

[jls]

Try setting each field that is to be updated to a value. For example:
UPDATE RunData SET Model='#Model#',
mAKE='#mAKE#',
ETC='#ETC#'
WHERE PriKey=#PriKey#

 

[kingjjx]

HEY .. THANKS A LOT .. FIXED THOSE 2 MINOR MISTAKES AND WORKED LIKE MAGIC.

AGAIN, THANK YOU