Re: Question about inserts

mike <mike(at)redtux1(dot)uklinux(dot)net> wrote:
>
> Is it possible to to the following
>
> I have tables which are updated via webpage (perl) with fields of type
> int and date (all nullable). If the values are blank the entire insert
> fails, with a wrong type error.

You're not giving much information here. What do you mean by "blank
field?" That is to say: If the field (on the web form) is left blank,
what is your CGI script trying to do?

>
> Is there any way to stop this behaviour so that the valid information is
> allowed,but the blank values get ignored.

One way would be not try to set table fields to invalid values ;).

Look into using placeholders in your prepared statements and
conditionally binding them to NULL if a web form field has been left
blank by the user.

--
Jim Seymour | Spammers sue anti-spammers:
jseymour(at)LinxNet(dot)com | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
| http://www.spamcon.org/legalfund/