Received: from mail.avsupport.com (mail.avsupport.com [207.70.233.2]) by hub.org (8.10.1/8.10.1) with SMTP id e7KFwCm35505 for ; Sun, 20 Aug 2000 11:58:12 -0400 (EDT) Received: from homebox.farcpe.cableone.net (homebox.farcpe.cableone.net [24.116.47.18]) by mail.avsupport.com (NTMail 3.03.0018/4c.adew) with ESMTP id ca603462 for ; Sun, 20 Aug 2000 10:58:55 -0500 Message-ID: <000601c00ac0$081275c0$122f7418@avsupport.com> From: "k.c. hemelstrand" To: Subject: update syntax error? Date: Tue, 15 Aug 2000 22:22:08 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C00707.40311D60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200008/194 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C00707.40311D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can anybody help with why I am receiving the error below? Thanks K.C. parts=3D# \d av_parts Table "av_parts" Attribute | Type | Modifier=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 ---------------------+-------------+---------------------------------------= ---------------- itemid | integer | not null default nextval('av_parts_ite= mid_seq'::text) vendorid | integer |=20 partnumber | varchar(25) |=20 alternatepartnumber | varchar(25) |=20 nsn | varchar(15) |=20 description | varchar(50) |=20 condition | varchar(10) |=20 quantity | integer |=20 rawpartnumber | varchar(25) |=20 rawalternatenumber | varchar(25) |=20 rawnsnnumber | varchar(15) |=20 date | integer |=20 cagecode | varchar(10) |=20 Indices: av_parts_alternatepartnumber_in, av_parts_itemid_key, av_parts_nsn_index, av_parts_partnumber_index, av_parts_rawalternatenumber_ind, av_parts_rawnsnnumber_index, av_parts_rawpartnumber_index, av_parts_vendorid_index parts=3D# UPDATE av_parts parts-# SET rawalternaternumber =3D 'NULL' AND alternatepartnumber =3D 'NUL= L' parts-# WHERE rawalternatenumber =3D 'IVA81A'; ERROR: left-hand side of AND is type 'unknown', not 'bool' ------=_NextPart_000_0007_01C00707.40311D60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Can anybody help with why I am receiving the error=20 below?
 
Thanks
K.C.
 
 
parts=3D# \d=20 av_parts
          &nb= sp;            =             &nb= sp;=20 Table "av_parts"
     =20 Attribute      |   =20 Type    =20 |            &n= bsp;         =20 Modifier           &= nbsp;           =20
---------------------+-------------+-----------------------------------= --------------------
 itemid      &nb= sp;      =20 | integer     | not null default=20 nextval('av_parts_itemid_seq'::text)
 vendorid   &nb= sp;       =20 | integer     |=20
 partnumber          = |=20 varchar(25) |
 alternatepartnumber | varchar(25) |=20
 nsn          &n= bsp;     =20 | varchar(15) |=20
 description         |=20 varchar(50) |=20
 condition         &n= bsp;=20 | varchar(10) |=20
 quantity         &nb= sp; =20 | integer     |=20
 rawpartnumber       | varchar(25) |= =20
 rawalternatenumber  | varchar(25) |=20
 rawnsnnumber        | varchar(= 15) |=20
 date          &= nbsp;    =20 | integer     |=20
 cagecode         &nb= sp; =20 | varchar(10) |
Indices:=20 av_parts_alternatepartnumber_in,
      &nb= sp; =20 av_parts_itemid_key,
        =20 av_parts_nsn_index,
        =20 av_parts_partnumber_index,
       &nb= sp;=20 av_parts_rawalternatenumber_ind,
      &nb= sp; =20 av_parts_rawnsnnumber_index,
       &= nbsp;=20 av_parts_rawpartnumber_index,
       =  =20 av_parts_vendorid_index
 

parts=3D# UPDATE av_parts
parts-# SET rawalterna= ternumber=20 =3D 'NULL' AND alternatepartnumber =3D 'NULL'
parts-# WHERE rawalternate= number =3D=20 'IVA81A';
ERROR:  left-hand side of AND is type 'unknown', not=20 'bool'
------=_NextPart_000_0007_01C00707.40311D60--