Reply-To: <jer@highboard.com>
From: "Jeremy Smith" <jer@highboard.com>
To: <pgsql-sql@postgresql.org>
Subject: Re: Inserting NULL into Integer column
Date: Wed, 18 Feb 2004 15:43:13 -0500
Message-ID: <FKEOIJEHOIKIOEHCGNCLGEMGEDAA.jer@highboard.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-Reply-To: <Pine.LNX.4.33.0402181317100.3215-100000@css120.ihs.com>
Importance: Normal


I've run into this kind of thing before.  IT helps if you have an array of
all your fields like:

$fields = array("field1","field3","last_name");

and then you can foreach across the input:

foreach($fields as $f){
  if (!$_POST[$f]){
    $_POST[$f]='DEFAULT';
  } else {
    $_POST[$f] = "'".$_POST[$f]."'";
  }
}

Wow, great idea.  I will definitely do this, thanks alot.


Well, you might find yourself rewriting fair portions of your site, but
usually you wind up with better code and better checking, so it's a bit of
a trade off.


No doubt that this is true.  Of course even without the better code and
error checking, the extra features like stored procedures and automatic row
locking was more than enough to make the switch worth it.

Thanks again!

Jeremy