pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David C. Brown <dbrown@centennialwines.com>
To: Jeff Self <jself@nngov.com>
Cc: Surojit Niyogi <surojit@bungeecode.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Problem involving checkbox and Postgresql
Date: Thu, 20 Jun 2002 02:57:18 -0500
Message-ID: <3D118ADE.7000709@centennialwines.com> (raw)
References: <1024591004.13953.13.camel@jselfpc>
	<3D12135F.4040309@bungeecode.com>
	<1024599680.13975.16.camel@jselfpc>

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
>>
>><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
>>    
>>





view thread (11+ messages)  latest in thread

Message-ID: <3D118ADE.7000709@centennialwines.com>
Permalink:  ../3D118ADE.7000709@centennialwines.com/
Also on:    postgresql.org/message-id/3D118ADE.7000709@centennialwines.com

 · 

reply

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: dbrown@centennialwines.com, jself@nngov.com, surojit@bungeecode.com
  Subject: Re: Problem involving checkbox and Postgresql
  In-Reply-To: <3D118ADE.7000709@centennialwines.com>
  References: <1024591004.13953.13.camel@jselfpc> <3D12135F.4040309@bungeecode.com> <1024599680.13975.16.camel@jselfpc> <3D118ADE.7000709@centennialwines.com>

* 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