Syntax error (missing operator) What am I missing here???

Wed, 26 Apr 2000 18:23:46 -0700 

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!&nbsp; I'm new at this.&nbsp; This is the error=20
message:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</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>&lt;cfquery name=3D"update" datasource=3D"1avanco" =
dbtype=3D"ODBC"&gt;</P>
<P>UPDATE Products2 <BR>&nbsp;SET ProdType=3D'#ProdType#'<BR>&nbsp;SET=20
ProductID=3D'#ProductID#'<BR>&nbsp;SET =
Product=3D'#Product#'<BR>&nbsp;SET=20
UnitPrice=3D'#UnitPrice#'<BR>&nbsp;SET =
Manufacturer=3D'#Manufacturer#'<BR>&nbsp;SET=20
DescShort=3D'#DescShort#'<BR>&nbsp;WHERE =
Code=3D#Code#<BR>&nbsp;&lt;/cfquery&gt;</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_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to