Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA75384 for ; Tue, 5 Oct 1999 12:32:27 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.8/8.8.8) with ESMTP id SAA25932; Tue, 5 Oct 1999 18:32:08 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <019801bf0f46$e1f01c00$40ee2fd8@venux.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 5 Oct 1999 18:32:03 +0200 To: "Mitch Vincent" , From: Herouth Maoz Subject: Re: [SQL] Reasonable At 17:32 +0200 on 05/10/1999, Mitch Vincent wrote: ... > "createdcond" varying(2), > "status" character varying(1) default 'Active', > "statuscond" character varying(1) default '=', > "firstname" character varying(25), > "firstnamecond" character varying(2) default '=', > "lastname" character varying(25), > "lastnamecond" character varying(2) default '=', > "address1" character varying(30), > "address1cond" character varying(2) default '=', > "address2" character varying(30), > "city" character varying(20), > "citycond" character varying(8) default 'starts', ... It's hard to know when you don't tell us which error message you got, but my guess is as follows: Most of these fields are defined using the syntax "fieldname" character varying(N)... But I seem to detect a couple of fields, "createdcond" above, as well as "dateavailablecond". Are those the fields you added? For some reason, they are defined as: "fieldname" varying(N)... Without the character keyword. On a cursory look this would not work. Another potential problem is your use of a six-letter long default for a varying(1) field ("status"). Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma