Re: [SQL] Reasonable

On Tue, Oct 05, 1999 at 11:32:50AM -0400, Mitch Vincent wrote:
...
> The query that's giving me fits :
>
>
>
> CREATE TABLE "user_applicant_search" (
> "app_id" int4,
> "created" datetime,
> "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',
> "state" character varying(10),
> "statecond" character varying(2) default '=',
> "email" character varying(50),
> "emailcond character varying(8) default 'starts',
... ^^^^^^

Don't you need a closing "?

Albert.

--

---------------------------------------------------------------------------
Post an / Mail to / Skribu al: Albert Reiner <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
---------------------------------------------------------------------------