I have already tried it but not working.. :( On Mon, Jun 28, 2010 at 6:01 PM, P Kishor <[email protected]> wrote:
> On Mon, Jun 28, 2010 at 9:58 AM, Serdar Genc <[email protected]> > wrote: > > Hi everyone, > > > > I have a problem related to column names . I have a column name as a[b] > in > > my table but > > this creates a problem when using SELECT statement as > > SELECT a[b] from Table. I know [] is a special character but How would I > > tell SQlite that field > > name is a[b] and I am not using [] with a special purpose.. > > Try SELECT "a[b]" > > > > > > Thanks in advance, > > Serdar > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Serdar Genç web: http://www.iptakip.com _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
