Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7714E47679C for ; Thu, 2 May 2002 18:03:48 -0400 (EDT) Received: from mail.bungeecode.com (aniyogi-5.mylinuxisp.com [216.39.203.94]) by postgresql.org (Postfix) with ESMTP id 70177476413 for ; Thu, 2 May 2002 17:21:19 -0400 (EDT) Received: from cs666899-134.austin.rr.com ([66.68.99.134] helo=bungeecode.com) by mail.bungeecode.com with esmtp (Exim 3.33 #1) id 173O28-0005cm-00; Thu, 02 May 2002 16:22:36 -0500 Message-ID: <3CD1ADAA.2060304@bungeecode.com> Date: Thu, 02 May 2002 16:20:42 -0500 From: Surojit Niyogi User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.0+) Gecko/20020429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "P. Jourdan" Cc: pgsql-php@postgresql.org Subject: Re: boolean error References: <5.1.0.14.2.20020502122037.00a6ef60@mail.host45.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/19 X-Sequence-Number: 1151 It can't understand color=red>YES> as a true or false representation for a boolean value. You need to use either (true or false), (yes or no), or (1 or 0) Roj Niyogi Founder pgHoster - PostgreSQL web hosting http://www.pghoster.com P. Jourdan wrote: > 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 ' color=red>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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >