I just posted the db on my website... there is one row and there aren't invisible characters.
Please note that the following query returns the exact row: SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin'; but I really don't have an explanation... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:10 AM, Martin Engelschalk wrote: > Hi, > > attachments do not make it through the list. > There is no row with the value 'admin' in the field 'lo_name' in your > table. Did you check that there are no blank spaces or other invisible > characters? > > Martin > > Marco Bambini wrote: >> Anyone can please explain me why this query: >> SELECT * FROM lo_user WHERE lo_name='admin'; >> returns 0 rows in this db? >> >> >> >> Thanks. >> -- >> Marco Bambini >> http://www.sqlabs.com >> http://www.creolabs.com/payshield/ >> >> >> >> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
