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
|