[mod_python] reg sql query

Mike Looijmans nlv11281 at natlab.research.philips.com
Mon Jan 9 04:51:17 EST 2006


Probably, your DBMS requires you to commit the data, e.g. using db.commit()

I would appreciate it if you post questions regarding generic Python and 
Oracle to a more appropriate maillist or newsgroup - they're not related 
to mod_python at all.

--
Mike Looijmans
Philips Natlab / Topic Automation


python eager wrote:
> Hi
>    i am insert three datas from form into sql through python. While 
> running there is no error. But the datas are not stored in that table. 
> If the values are print through self.writeln(fieldname). it will be 
> working properly. the values are not stored in that table..
> All the connections are nice.
>  
>  cursor.execute("INSERT INTO 
> PERSONALDETAILS(FIRSTNAME,MIDDLENAME,LASTNAME) VALUES ('%s', '%s', '%s')"
>                          % (fname,mname,lname))
>  
> Please solve this problem.
>  
> Thank you
>  
> bye
> Python Eager
>  
>  
> 
> ------------------------------------------------------------------------
> Yahoo! DSL 
> <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=37474/*http://promo.yahoo.com/broadband/ 
>  > Something to write home about. Just $16.99/mo. or less
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Mod_python mailing list
> Mod_python at modpython.org
> http://mailman.modpython.org/mailman/listinfo/mod_python



More information about the Mod_python mailing list