How to convert None to null value

[pradeep kumar]

Hi ,

i am trying to insert records from one table to another table in postgres
sql using the the following code

posConn.query("insert into
usr(usr_id,usr_name,usr_passwd,grp_cde,usr_type,usr_chk_till_val, \

usr_active,usr_daily_auth,usr_lst_login,usr_lst_logout,usr_shift_id,usr_role_level)
values \
             ('%s','%s','%s',%s,%i,%d,'%s',%i,%i,%i,%i,%i)"
%(row[0],row[1],row[2],row[3],row[4],row[5], \
              row[7],row[8],row[10],row[11],row[12],row[14]) )

here row[4] column is having null value so python consides it as None but
will insert into the table it inserts as None not null value

please help how to convert None to null value
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20070907/c255ef04/attachment.html>