mike <mike@redtux1.uklinux.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@LinxNet.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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
