This is a multi-part message in MIME format.
------=_NextPart_000_029A_01C039D5.90425F20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This is really off topic but.............. this code works in SQL =
server, but does not work in Access which this POS db is unfortunately =
in. All I want to do is import a new column into an existing db. I could =
definately do this in CF, but there are around 11000 records...
Update Products
Set ProductCat =3D (Select ProductCat FROM pricecat where partnumber1 =
=3D a.partnumber)
FROM products a=20
I get this error:
Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) =
in query expression ''(Select ProductCat FROM pricecat where =
'partnumber1' =3D 'partnumber')''
I get the same error when putting this directly into Access.
What am I doing wrong? This should be a simple thing....
jon
------=_NextPart_000_029A_01C039D5.90425F20
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.3018.900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>This is really off topic =
but.............. this=20
code works in SQL server, but does not work in Access which =
this POS db is=20
unfortunately in. All I want to do is import a new column into an =
existing db. I=20
could definately do this in CF, but there are around 11000=20
records...</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Update Products<BR>Set ProductCat =3D =
(Select=20
ProductCat FROM pricecat where partnumber1 =3D a.partnumber)<BR>FROM =
products a=20
<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I get this error:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Microsoft][ODBC Microsoft Access =
Driver] Syntax=20
error (missing operator) in query expression ''(Select ProductCat FROM =
pricecat=20
where 'partnumber1' =3D 'partnumber')''</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I get the same error when putting this =
directly=20
into Access.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>What am I doing wrong? This should be a =
simple=20
thing....</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>jon</FONT></DIV></BODY></HTML>
------=_NextPart_000_029A_01C039D5.90425F20--
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
