yes you are correct, but even when i rewrite the typo, there was no result (i got an empty one) i mean with the originald table, not the present in letter (i got it with sqlite explorer export function) but when i select all from the db with sqlite.exe i saw, that in this column the data was ... NULLs and some strings (garbage). Now i put corect data (numbers) and all is ok - so 10x !
regards e. Цитат на писмо от Reid Thompson <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > thanks > > > > actualy the problem was in the sqlite explorer because > the > > column was defined as integer and any text is > interpreted > > as zero :-) > > > > > no, actually i think Guillaume was correct. > This is the query you posted: > > SELECT statid > FROM plan P1 > WHERE P1.curseid = 0; > > Note in your data that NO curseid is equal to 0. They > are all set to 1. > > > >> [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 > > > > > > > > >