Re: [Tutor] sqlite3 select extra characters

Steven D'Aprano wrote: On Fri, 18 Jun 2010 03:54:05 pm Lang Hurst wrote: Is there a way to just return the values when using sqlite3? If I: names = c.execute('select names from students') for name in names: print names What is c? A Cursor or a Connection object? It probably d

Re: [Tutor] sqlite3 select extra characters

Thanks. Alan Gauld wrote: "Lang Hurst" wrote Is there a way to just return the values when using sqlite3? I don't think so, select returns a tuple of values, even if there is only one value. I get the list I want, but they look like (u'Cleese, John') is there a way to just return C

Re: [Tutor] sqlite3 select extra characters

On Fri, 18 Jun 2010 03:54:05 pm Lang Hurst wrote: > Is there a way to just return the values when using sqlite3? > > If I: > > names = c.execute('select names from students') > for name in names: print names What is c? A Cursor or a Connection object? It probably doesn't make any real dif

Re: [Tutor] sqlite3 select extra characters

"Lang Hurst" wrote Is there a way to just return the values when using sqlite3? I don't think so, select returns a tuple of values, even if there is only one value. I get the list I want, but they look like (u'Cleese, John') is there a way to just return Cleese, John It seems a sham