[mod_python] reg sql query

Julien Cigar jcigar at ulb.ac.be
Mon Jan 9 05:11:32 EST 2006


The correct syntax is :
cursor.execute("INSERT INTO 
PERSONALDETAILS(FIRSTNAME,MIDDLENAME,LASTNAME) VALUES (%s, %s, %s)", 
(fname, mname, lname))

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/%20> 
> 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
>  
>


-- 
Julien Cigar
Belgian Biodiversity Platform
http://www.biodiversity.be
Université Libre de Bruxelles
Campus de la Plaine CP 257
Bâtiment NO, Bureau 4 N4 115C (Niveau 4)
Boulevard du Triomphe, entrée ULB 2
B-1050 Bruxelles
Work: jcigar at ulb.ac.be
Personal: mage at mordor.ath.cx



More information about the Mod_python mailing list