From: | Surojit Niyogi <surojit(at)bungeecode(dot)com> |
---|---|
To: | "P(dot) Jourdan" <pippo(at)videotron(dot)ca> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: boolean error |
Date: | 2002-05-02 21:20:42 |
Message-ID: | 3CD1ADAA.2060304@bungeecode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
It can't understand
<font >color=red><b>YES></b></font>
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 '<font
> >color=red><b>YES></b></font>'
>
> 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="<font color=red><b>YES</b></font>";
> }
> ;;;
>
> select wares.ware_id,wares.name,category.name,unit_size,
> qty_per_shipping_unit,supplier.name,sku,
> case when wares.archived='t' then '<font
> color=red><b>YES</b></font>' 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2002-05-02 21:31:35 | Re: column insert |
Previous Message | Dave Page | 2002-05-02 20:38:00 | Re: [PHP] sql commands |