Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id BF1664769E6 for ; Thu, 2 May 2002 14:07:55 -0400 (EDT) Received: from VL-MS-MR004.sc1.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id 06E174764AF for ; Thu, 2 May 2002 12:31:00 -0400 (EDT) Received: from pippo.videotron.ca ([24.203.142.29]) by VL-MS-MR004.sc1.videotron.ca (Netscape Messaging Server 4.15) with ESMTP id GVHSJT03.WWS for ; Thu, 2 May 2002 12:31:05 -0400 Message-Id: <5.1.0.14.2.20020502122037.00a6ef60@mail.host45.com> X-Sender: vltazczw@pop.videotron.ca X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 02 May 2002 12:31:07 -0400 To: pgsql-php@postgresql.org From: "P. Jourdan" Subject: boolean error Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200205/14 X-Sequence-Number: 1146 I am getting this in the error log file: ERROR: Bad boolean external representation 'color=red>YES>' The code that is generating the message is all within the php delimiters (entire file) and appears several times as follows: if($r1==0 || $r2==0) { if($archived=='Y') { $archived="YES"; } ;;; select wares.ware_id,wares.name,category.name,unit_size, qty_per_shipping_unit,supplier.name,sku, case when wares.archived='t' then 'YES' else wares.archived end as archived, trademark.name from wares,category,wares_category,supplier_wares,supplier,trademark where wares.ware_id=wares_category.ware_id and category.category_id=wares_category.category_id and wares.ware_id=supplier_wares.ware_id and supplier_wares.supplier_id=supplier.supplier_id and wares.trademark_id=trademark.trademark_id"; I do not understand what is wrong? (This apparently worked fine in the original online web site.) Does anyone understand this? Philip Jourdan