From: "Dan Kennedy"...
On Tue, 2007-06-26 at 17:50 -0400, jose isaias cabrera wrote:Greetings. 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 );
... ... ...
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.
Ok, Dan, I agree. But why do these both work? sqlite> select * from LSOpenJobs where id=247; 247|245|245|245||...|n||c and this one... sqlite> select * from LSOpenJobs where id='247'; 247|245|245|245||...|n||c Should the last one not work? ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
