On Fri, May 14, 2010 at 12:38 PM, Fabio Spadaro <fabiolinos...@gmail.com>wrote:
> > No, i'm sure. Probably typeof in python's sqlite is not supported very mell > or there is other explanation. > It works perfectly in Python: In [2]: import sqlite3 In [3]: conn = sqlite3.connect(':memory:') In [4]: c = conn.cursor() In [5]: c.execute("CREATE TABLE tabA (a INTEGER, B INTEGER)") In [6]: c.execute("INSERT INTO tabA VALUES (1,10)") In [7]: c.execute("INSERT INTO tabA VALUES (2,20)") In [8]: c.execute("CREATE TABLE tabB (theNum INTEGER, theName TEXT)") In [9]: c.execute("INSERT INTO tabB VALUES (10,'albert')") In [10]: c.execute("INSERT INTO tabB VALUES (20,'bertha')") In [11]: res = c.execute("SELECT tabA.a,tabB.theNum,tabB.theName,typeof(tabB.theNum),typeof(tabB.theName) FROM tabA JOIN tabB ON tabB.theNum = tabA.b") In [12]: for r in res.fetchall(): print r ....: (1, 10, u'albert', u'integer', u'text') (2, 20, u'bertha', u'integer', u'text') Regards, Mikhail Terekhov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users