On Tue, 2007-06-26 at 17:50 -0400, jose isaias cabrera wrote: > Greetings. > > I have the following db declarations: > > SQLite version 3.3.8 > Enter ".help" for instructions > sqlite> .schema > CREATE TABLE LSOpenJobs > ( > id integer primary key, ProjID integer, subProjID, parent, > children, login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm, > pmuk, lang, vendor, vEmail, invoice, ProjFund, PMTime, A_No, wDir, BiliDir, > TMDir, DeliveryDir, paid, paidDate, notes, status > ); > CREATE TABLE LSOpenProjects > ( > id integer primary key, ProjID integer, subProjID, parent, children, > login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm, pmuk, lang, > vendor, vEmail, invoice, ProjFund, PMTime, A_No, wDir, BiliDir, TMDir, > DeliveryDir, paid, paidDate, notes, status > ); > CREATE TABLE LSOpenSubProjects > ( > id integer primary key, ProjID integer, subProjID, parent, children, > login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm, pmuk, lang, > vendor, vEmail, invoice, ProjFund, PMTime, A_No, wDir, BiliDir, TMDir, > DeliveryDir, paid, paidDate, notes, status > ); > CREATE TABLE PMTime (id integer primary key, rec integer, date, secs > integer); > CREATE TABLE PMUserData > ( > login primary key, > Name, > Password, > email, > phone, > homephone, > Lang, > ProjOwned > ); > > If I do this call, > > sqlite> select * from LSOpenJobs where SubProjID='22'; > > I get nothing. If I do this call, > sqlite> select * from LSOpenJobs where SubProjID=22; > 106|22|22|22||...|c > 107|22|22|22||...|c > 108|22|22|22||...|c > 109|22|22|22||...|c > sqlite> > > I get stuff. Anybody would like to tell me why? I have done some command > prompt manual record deletion and edition, but it should not matter, > correct?
It's about the differences between a string and a number, how they compare and when a string is converted to a number. See section 3 of this page: http://www.sqlite.org/datatype3.html Dan. > thanks, > > josé > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
