thanks actualy the problem was in the sqlite explorer because the column was defined as integer and any text is interpreted as zero :-)
Цитат на писмо от Guillaume MAISON <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] a ?crit : > > hi guys > > i need help :-) > > > > what is the problem : > > (SQLite version 3.3.4, win XP) > > > > i have a table: > > > > CREATE TABLE plan(personid INTEGER, curseid INTEGER, > statid > > INTEGER); > > INSERT INTO plan VALUES(1,1,0); > > INSERT INTO plan VALUES(2,1,0); > > INSERT INTO plan VALUES(3,1,0); > > INSERT INTO plan VALUES(4,1,NULL); > > INSERT INTO plan VALUES(5,1,NULL); > > INSERT INTO plan VALUES(6,1,NULL); > > INSERT INTO plan VALUES(7,1,NULL); > > INSERT INTO plan VALUES(8,1,NULL); > > -- ... > > > > and i need to select all rows with "statid" = 0 > > so the query is : > > SELECT statid > > FROM plan P1 > > WHERE P1.curseid = 0; > > > > BUT what a surprise, i got an empty result (i expect to > get > > rows No 1 to 3) ! > > > > any suggestions? > > Yes : > SELECT P1.statid > FROM plan P1 > WHERE P1.statid = 0; > > instead of your query... > > but you'll get only what you asked for : only O ;) > > > -- > > Guillaume MAISON - [EMAIL PROTECTED] > 83, Cours Victor Hugo > 47000 AGEN > T?l : 05 53 87 91 48 - Fax : 05 53 68 73 50 > e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com > > > ----------------------------- Slon.bg ™ Симпатичният магазин за книги, DVD, игри и музика http://www.slon.bg
