Re: Problem involving checkbox and Postgresql - Mailing list pgsql-php
From | Surojit Niyogi |
---|---|
Subject | Re: Problem involving checkbox and Postgresql |
Date | |
Msg-id | 3D1237AF.7090702@bungeecode.com Whole thread Raw |
In response to | Re: Problem involving checkbox and Postgresql (Chris Thompson <thompson@ednet.co.uk>) |
List | pgsql-php |
I suppose it works well with radio buttons where you at least have a "Yes" and "No" option.<br /><br /> Chris Thompson wrote:<br/><blockquote cite="midPine.LNX.4.33L2.0206202101340.24168-100000@boyce.ednet.co.uk" type="cite"><pre wrap="">Thencheck if($driving_required==1) { $bleh='t'} else { $bleh='f'} On 20 Jun 2002, Jeff Self wrote: </pre><blockquote type="cite"><pre wrap="">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: </pre><blockquote type="cite"><pre wrap="">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: </pre><blockquote type="cite"><pre wrap="">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"><inputtype="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? </pre></blockquote><pre wrap=""> ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to <a class="moz-txt-link-abbreviated" href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>so that your message can get through to the mailing list cleanly </pre></blockquote><pre wrap="">-- Jeff Self Information Technology Analyst Department of Personnel City of Newport News 2400 Washington Avenue Newport News, VA 23607 757-926-6930 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to <a class="moz-txt-link-abbreviated" href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>so that your message can get through to the mailing list cleanly -- Virus scanned by edNET. </pre></blockquote><pre wrap=""> </pre></blockquote>