I used java script to validate before passing values it to the backend.
The options of adding constraints to the backend is a good idea. I did
thru alter constraint. Thanks...
-vimala/.
On Tue, 16 Sep 2003, scott.marlowe wrote:
> Sure, you just need a constraint:
>
> create table test (info text constraint "no blanks" check (info<>'' and info<>' ') not null);
> CREATE TABLE
> insert into test (info) values ('');
> ERROR: new row for relation "test" violates CHECK constraint "no blanks"
>
> I'm not sure how to add constraints to already existing tables, so you
> might wanna do this in a test table, move your data over, then rename
> tables to swap in the new table.
>
> On Tue, 16 Sep 2003, S.P.Vimala wrote:
>
> >
> >
> > I think u are right, My code goes like this.......
> >
> >
> > This is what i do in my html page
> > $result = insert_user($userloginid,$username,$password,$usertype,$txtAddress,
> > $phoneno,$email);
> >
> > The function insert_user is like this.
> >
> > function insert_user($loginid,$username,$password,$usertype,$txtAddress,$phoneno,$email){
> > if($dbhandle=get_dbconnection())
> > {
> > $query="insert into vyapar_user values('". $loginid .
> > "','" . $username . "','" . $password . "','" . $usertype . "','" .
> > $txtAddress . "','" . $phoneno . "','" . $email . "')";
> > $result=pg_exec($dbhandle,$query);
> > if(!result)
> > return null;
> > else
> > return $result;
> > }
> > }
> >
> >
> > I need to prevent '' as well as ' ' entry into the db which are also null
> > values may be not theoritically but in practice they are....
> >
> > so any suggestions?
> >
> >
> >
> > > On Mon, 15 Sep 2003, S.P.Vimala wrote:
> > >
> > > > Hi,
> > > >
> > > > I have a table in postgresql db with the following description.
> > > >
> > > > - Table: vyapar_user
> > > > CREATE TABLE vyapar_user (
> > > > loginid varchar(150) NOT NULL,
> > > > name varchar(150) NOT NULL,
> > > > "password" varchar(32) NOT NULL,
> > > > "type" varchar(10) NOT NULL,
> > > > address varchar(100) NOT NULL,
> > > > phone varchar(15),
> > > > email varchar(20),
> > > > creationdate date DEFAULT date('now'::text),
> > > > expriydate date DEFAULT (date('now'::text) + 360),
> > > > CONSTRAINT vyapar_user_pk PRIMARY KEY (loginid)
> > > > ) WITH OIDS;
> > > >
> > > >
> > > > If i try inserting NULL values from backend, then it gives me an
> > > > error. But thru php, its adds null values without any errors. Any idea
> > > > how to solve this issue.....
> > >
> > > I'll need to see some sample code. In my experience, PHP cannot insert
> > > NULLS into not null fields.
> > >
> > > Are you sure you're not inserting '' and thinking of it as NULL? They're
> > > not the same.
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 9: the planner will ignore your desire to choose an index scan if your
> > > joining column's datatypes do not match
> > >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
