change a value to NULL?
Steve Holden
steve at holdenweb.com
Wed Oct 5 12:35:05 EDT 2005
Brett Hoerner wrote:
> I'm not sure what you mean, really, do you need an official Python
> "Null" value? Try None?
>
> In [6]: myCells = ['Mary', 'Bob', None, 'Joe']
>
> In [7]: for cell in myCells:
> ...: if cell:
> ...: print cell
> ...: else:
> ...: print "NULL VALUE"
> ...:
> Mary
> Bob
> NULL VALUE
> Joe
>
> --
>
> As far as having a Null value to put into the DB, most (SQL) DB's I've
> used have a specific SQL command like "INSERT INTO ROW VALUE NULL()",
> kind of like the SQL DATE(), etc. I'm really rusty on my syntax etc
> right now btw so don't copy and paste that. :P
>
And besides that, Excel is a spreadsheet not a database :-)
regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/
More information about the Python-list
mailing list