Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9E8D7475CC6 for ; Thu, 20 Jun 2002 16:14:46 -0400 (EDT) Received: from enterprise.centliq.com (adsl-65-71-224-185.dsl.rcsntx.swbell.net [65.71.224.185]) by postgresql.org (Postfix) with ESMTP id 9CC2A476762 for ; Thu, 20 Jun 2002 15:57:45 -0400 (EDT) Received: from centennialwines.com (unknown [192.168.1.2]) by enterprise.centliq.com (Postfix) with ESMTP id 0DD99FF009; Thu, 20 Jun 2002 14:48:02 -0500 (CDT) Message-ID: <3D118ADE.7000709@centennialwines.com> Date: Thu, 20 Jun 2002 02:57:18 -0500 From: "David C. Brown" User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.0.0) Gecko/20020530 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jeff Self Cc: Surojit Niyogi , pgsql-php@postgresql.org Subject: Re: Problem involving checkbox and Postgresql References: <1024591004.13953.13.camel@jselfpc> <3D12135F.4040309@bungeecode.com> <1024599680.13975.16.camel@jselfpc> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/36 X-Sequence-Number: 1289 It returns "on" as true. Just test the value of $driving_required and assign the proper boolen value for postgresql.. If ($driving_required=='on') { $driving_required=TRUE; } else { $driving_required=FALSE; } Dave Jeff Self wrote: >That only works if I leave the checkboxes checked. If I remove the >check, I get the following error: > >Warning: pg_exec() query failed: ERROR: Bad boolean external >representation '' > in /var/www/nngov/admin/jobpostresults.php on line 66 > >On Thu, 2002-06-20 at 13:39, Surojit Niyogi wrote: > > >>Hi Jeff, >> >>Set the value parameter in the input tag >> >>>name="driving_required" CHECKED value='1'> >> >>That should work I believe. >> >>-Surojit >> >>Jeff Self wrote: >> >> >> >>>I've got a table with a field called driving_required with a boolean >>>type and default 'true'. I've built a web page which contains the >>>following lines for displaying a checkbox: >>> >>>Driver's License Required? >>> >>name="driving_required" CHECKED> >>> >>>After the form is submitted, it calls a php file called >>>jobpostresults.php which enters the data from the form into the database >>>and displays the results on the page. >>> >>>Here's the section that enters the form data into the database: >>> >>>// Add Job Description Details >>>$jddquery = "INSERT INTO job_description_details (description_id, >>>effective_date, driving_required, submitted_on, submitted_by, >>>sm_description, responsibilities, behaviors, skills, experience, >>>requirements) VALUES >>>('$description_id','$effective_date','$driving_required',now(),'$submitted_by','$sm_description','$responsibilities','$behaviors','$skills','$experience','$requirements')"; >>> >>>$jddresult = pg_exec($conn, $jddquery); >>>if (!$jddresult) >>> exit; >>> >>>When I input the data and click on submit I get the following error >>>message: >>> >>>Warning: pg_exec() query failed: ERROR: Bad boolean external >>>representation 'on' >>>in /var/www/nngov/admin/jobpostresults.php on line 46 >>> >>>It looks like the html form is producing 'on' for the value of >>>driving_required. How do I get this changed to 'true' in PostgreSQL? >>> >>> >>> >>> >>> >>---------------------------(end of broadcast)--------------------------- >>TIP 3: if posting/reading through Usenet, please send an appropriate >>subscribe-nomail command to majordomo@postgresql.org so that your >>message can get through to the mailing list cleanly >> >>