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@tph.tuwien.ac.at>
 
---------------------------------------------------------------------------