Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id CEE16476EB9 for ; Thu, 20 Jun 2002 15:12:39 -0400 (EDT) Received: from visi.net (arsenal.visi.net [206.246.194.60]) by postgresql.org (Postfix) with ESMTP id 73210476DC6 for ; Thu, 20 Jun 2002 15:01:31 -0400 (EDT) X-Virus-Scanner: McAfee Virus Engine Received: from [216.54.6.254] (HELO localhost.localdomain) by visi.net (CommuniGate Pro SMTP 3.5.6) with ESMTP id 35002654; Thu, 20 Jun 2002 15:00:09 -0400 Subject: Re: Problem involving checkbox and Postgresql From: Jeff Self To: Surojit Niyogi Cc: pgsql-php@postgresql.org In-Reply-To: <3D12135F.4040309@bungeecode.com> References: <1024591004.13953.13.camel@jselfpc> <3D12135F.4040309@bungeecode.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.7 Date: 20 Jun 2002 15:01:19 -0400 Message-Id: <1024599680.13975.16.camel@jselfpc> Mime-Version: 1.0 X-Archive-Number: 200206/35 X-Sequence-Number: 1288 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 -- Jeff Self Information Technology Analyst Department of Personnel City of Newport News 2400 Washington Avenue Newport News, VA 23607 757-926-6930