Re: [Tutor] String representation of NULL (non type) values

2013-11-05 Thread Joel Goldstick
On Tue, Nov 5, 2013 at 2:40 PM, Walter Prins wrote: > Hi, > > > On 5 November 2013 19:02, Danny Yoo wrote: >>> >>> Be extra careful if you're constructing SQL statements from user input. >>> You have probably heard of the term "SQL Injection" or "Bobby Tables", both >>> of which are pretty much t

Re: [Tutor] String representation of NULL (non type) values

2013-11-05 Thread Walter Prins
Hi, On 5 November 2013 19:02, Danny Yoo wrote: > Be extra careful if you're constructing SQL statements from user input. >> You have probably heard of the term "SQL Injection" or "Bobby Tables", >> both of which are pretty much the same thing: your user may, intentionally >> or not, input valu

Re: [Tutor] String representation of NULL (non type) values

2013-11-05 Thread Danny Yoo
> > > from a SQLite database I get a value by SELECT s from... which normaly is > a string, but can be the NULL value, wich means it is not defined. To put > the value into a form (made by QT) I need a string representation. > > str(s) gives either the string itself (which is good) or "None" (which

Re: [Tutor] String representation of NULL (non type) values

2013-11-05 Thread Peter Otten
Ulrich Goebel wrote: > Hallo, > > from a SQLite database I get a value by SELECT s from... which normaly > is a string, but can be the NULL value, wich means it is not defined. To > put the value into a form (made by QT) I need a string representation. > > str(s) gives either the string itself (

Re: [Tutor] String representation of NULL (non type) values

2013-11-05 Thread Steven D'Aprano
On Mon, Nov 04, 2013 at 11:34:01AM +0100, Ulrich Goebel wrote: > Hallo, > > from a SQLite database I get a value by SELECT s from... which normaly > is a string, but can be the NULL value, wich means it is not defined. To > put the value into a form (made by QT) I need a string representation. >

Re: [Tutor] String representation of NULL (non type) values

2013-11-05 Thread Joel Goldstick
On Mon, Nov 4, 2013 at 5:34 AM, Ulrich Goebel wrote: > Hallo, > > from a SQLite database I get a value by SELECT s from... which normaly is a > string, but can be the NULL value, wich means it is not defined. To put the > value into a form (made by QT) I need a string representation. > > str(s) gi

[Tutor] String representation of NULL (non type) values

2013-11-05 Thread Ulrich Goebel
Hallo, from a SQLite database I get a value by SELECT s from... which normaly is a string, but can be the NULL value, wich means it is not defined. To put the value into a form (made by QT) I need a string representation. str(s) gives either the string itself (which is good) or "None" (which