On 5/1/01, Thomas Chiverton penned:
>I have:
><cfquery name="update2" datasource="ps_skills">
>update con_list set note = 'dr' where userid = #session.userid# and skill =
>#form.skill#
></cfquery>
>And it is dieing with:
>ODBC Error Code = 37000 (Syntax error or access violation)
>[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
>SQL = "update con_list set note = 'dr' where userid = 32715281 and skill =
>1"
Off the top of my head it looks like note may be a number field. In
which case you will get that error if you try to insert anything but
a number.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
