Hi, 2010/5/14 P Kishor <punk.k...@gmail.com>
> On Fri, May 14, 2010 at 9:49 AM, Fabio Spadaro <fabiolinos...@gmail.com> > wrote: > > hi, > > > > 2010/5/14 P Kishor <punk.k...@gmail.com> > > > >> On Fri, May 14, 2010 at 9:01 AM, Fabio Spadaro <fabiolinos...@gmail.com > > > >> wrote: > >> > I need to identify data types extracted from a > >> > join between multiple tables without using cross-checking table_info > more > >> > pragmatic. > >> > > >> > >> Could you clarify what you really want to do? Your question is not > >> clear at all, at least to me. What do you mean by "using > >> cross-checking table_info more pragmatic"? More pragmatic than what? > >> > >> > Is there a faster way to do it? > >> > > >> > >> Faster than what? > >> > >> If you want data_types, you can use SELECT Typeof(column_name) > >> > >> > >> > >> > >> > > >> > >> > >> > >> -- > >> Puneet Kishor http://www.punkish.org > >> Carbon Model http://carbonmodel.org > >> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > >> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > >> Nelson Institute, UW-Madison http://www.nelson.wisc.edu > >> ----------------------------------------------------------------------- > >> Assertions are politics; backing up assertions with evidence is science > >> ======================================================================= > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > I use python sqlite embedded and in my application I have a panel where > you > > can > > type a query and see the results in a panel's grid > > Now suppose that I type a query like "select > > a.field1, b.field2 from table1 a, table2 b " such data > > will be displayed in grid but I need to know what types of data I > obtained. > > How do it? > > > SELECT a.field1, Typeof(a.field1), b.field2, Typeof(b.field2) > FROM table1 a, table2 b... > > > > > > -- > > Fabio Spadaro > > www.fabiospadaro.com > > _______________________________________________ > > 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 > It does not work, It always return data type text. -- Fabio Spadaro www.fabiospadaro.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
