From: Jeff Self <jself@nngov.com>
To: Surojit Niyogi <surojit@bungeecode.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Problem involving checkbox and Postgresql
Date: 20 Jun 2002 15:01:19 -0400
Message-ID: <1024599680.13975.16.camel@jselfpc> (raw)
In-Reply-To: <3D12135F.4040309@bungeecode.com>
References: <1024591004.13953.13.camel@jselfpc>
<3D12135F.4040309@bungeecode.com>
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
>
> <input type="checkbox"
> 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:
> >
> ><tr><td width="25%" class="form">Driver's License Required?</td>
> > <td width="75%" class="form"><input type="checkbox"
> >name="driving_required" CHECKED></td></tr>
> >
> >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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: jself@nngov.com, surojit@bungeecode.com
Subject: Re: Problem involving checkbox and Postgresql
In-Reply-To: <1024599680.13975.16.camel@jselfpc>
References: <1024591004.13953.13.camel@jselfpc> <3D12135F.4040309@bungeecode.com> <1024599680.13975.16.camel@jselfpc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox