UPDATE TableName
SET ColumnName1 = value1,
SET ColumnName2 = value2,
.
.
.
SET ColumnNamwn = valuen
the value van be a variable:
#variableName#
any values for non-numneric columns must be enclosed in single quotes:
'#NonNumericVariaqbleName#'
a comma follows each SET clause except the last.
Dick
At 5:38 PM -0700 4/26/2000, Britta Wingenroth \(Design Department\) wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0005_01BFAFA6.45CCE0F0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>If you can see the problem, a solution would be greatly appreciated! =
>I'm new at this. This is the error message:
>
>ODBC Error Code =3D 37000 (Syntax error or access violation)=20
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing =
>operator) in query expression ''Laptop' SET ProductID=3D'123' SET =
>Product=3D'testt' SET UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET =
>DescShort=3D'df''.=20
>
>
>
>The error occurred while processing an element with a general identifier =
>of (CFQUERY),=20
>
>This is my code, with the variables passed from a form:
>
><cfquery name=3D"update" datasource=3D"1avanco" dbtype=3D"ODBC">
>
>UPDATE Products2=20
> SET ProdType=3D'#ProdType#'
> SET ProductID=3D'#ProductID#'
> SET Product=3D'#Product#'
> SET UnitPrice=3D'#UnitPrice#'
> SET Manufacturer=3D'#Manufacturer#'
> SET DescShort=3D'#DescShort#'
> WHERE Code=3D#Code#
> </cfquery>
>
>Thanks a lot,=20
>
>Britta
>
>
>------=_NextPart_000_0005_01BFAFA6.45CCE0F0
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content=3D"text/html; charset=3Diso-8859-1" =
>http-equiv=3DContent-Type>
><META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV><FONT face=3DArial size=3D2>If you can see the problem, a solution =
>would be=20
>greatly appreciated! I'm new at this. This is the error=20
>message:</FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT> </DIV>
><DIV><FONT face=3DArial size=3D2>ODBC Error Code =3D 37000 (Syntax error =
>or access=20
>violation) </DIV>
><P>
><P>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing =
>operator) in=20
>query expression ''Laptop' SET ProductID=3D'123' SET Product=3D'testt' =
>SET=20
>UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET DescShort=3D'df''.=20
><P>
><P>
><P>The error occurred while processing an element with a general =
>identifier of=20
>(CFQUERY), </P>
><P>This is my code, with the variables passed from a form:</P>
><P><cfquery name=3D"update" datasource=3D"1avanco" =
>dbtype=3D"ODBC"></P>
><P>UPDATE Products2 <BR> SET ProdType=3D'#ProdType#'<BR> SET=20
>ProductID=3D'#ProductID#'<BR> SET =
>Product=3D'#Product#'<BR> SET=20
>UnitPrice=3D'#UnitPrice#'<BR> SET =
>Manufacturer=3D'#Manufacturer#'<BR> SET=20
>DescShort=3D'#DescShort#'<BR> WHERE =
>Code=3D#Code#<BR> </cfquery></P>
><P>Thanks a lot, </P>
><P>Britta</P></FONT></BODY></HTML>
>
>------=_NextPart_000_0005_01BFAFA6.45CCE0F0--
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
