db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberto Lopez <roberto.lo...@rhiscom.com>
Subject problem in query
Date Fri, 06 Aug 2010 22:29:43 GMT
Hi, i need execute to query, mi table is 

CREATE TABLE PEOPLE (
    ID VARCHAR(256) NOT NULL,
    NAME VARCHAR(1024) NOT NULL,
    APPPASSWORD VARCHAR(1024),
    CARD VARCHAR(1024),
    ROLE VARCHAR(256) NOT NULL,
    VISIBLE SMALLINT NOT NULL,
    COMMISION VARCHAR(256),
    IMAGE BLOB,
    PRIMARY KEY (ID),
    CONSTRAINT PEOPLE_FK_1 FOREIGN KEY (ROLE) REFERENCES ROLES(ID),
    CONSTRAINT PEOPLE_FK_2 FOREIGN KEY (COMMISION) REFERENCES
COMMISION(ID)
);



when execute the query


SELECT DISTINCT ID, NAME, APPPASSWORD, CARD, ROLE, VISIBLE, COMMISION,
IMAGE WHERE ...


the derby throw the error why not can DISCTINCT applicate to fields of
type BLOB.. how i can execute mi query


thanks

Best Regards 


Mime
View raw message