This might be because desc is a reserved word in MS SQL.
Check the docs for the platform you're on and see if this might be
the problem.
Regards,
Stephen
HTH,
Stephen
> Hello cf-talk,
>
> This simple update is generating a syntax error i can't seem to
> resolve. What am I missing??
>
>
>
> <cfquery DATASOURCE="#Application.dsn#">
> UPDATE #form.table#
> SET name='#name#',
> desc='#desc#',
> price='#price#'
> WHERE id=#form.id#
> </cfquery>
>
>
>
>
> Best regards,
> Jeff Fongemie mailto:[EMAIL PROTECTED]
> ------------------------ Internet Guns For Hire (603) 356-0768
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists