Received: from itd.nrl.navy.mil (s2.itd.nrl.navy.mil [132.250.83.3]) by hub.org (8.9.1/8.9.1) with ESMTP id KAA11129 for ; Tue, 29 Dec 1998 10:39:59 -0500 (EST) (envelope-from holston@itd.nrl.navy.mil) Received: from shell (shell [132.250.83.3]) by itd.nrl.navy.mil (8.8.8/8.8.8) with SMTP id KAA08001 for ; Tue, 29 Dec 1998 10:39:49 -0500 (EST) Date: Tue, 29 Dec 1998 10:39:49 -0500 (EST) From: Gregory Holston X-Sender: holston@shell To: pgsql-sql@hub.org Subject: booleans In-Reply-To: <199812290400.XAA29444@hub.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Good day all, I just wrote an HTML form with a PHP script to enter data into a table witha boolean field. When I pressed enter it returned the following error "Warning: PostgresSQL query failed: ERROR: Bad boolean external representation". The script is as follows: if( $id ) { pg_Exec($conn, "INSERT into authors VALUES ('$pubrelease', '$id', '$first');"); } I would appreciate any help. Thanks, -Greg