python eager
python_eager at yahoo.com
Mon Jan 9 08:01:17 EST 2006
Hi i m getting the following errors. Please solve this problem Hi this is my code snippet. req = self.request() fname = req.field('fname') mname = req.field('mname') lname = req.field('lname') dbconnection = cx_Oracle.connect("myuser", "mypassword", "mydatabase") cursor = dbconnection.cursor() cursor.arraysize = 50 self.writeln("hello") cursor.execute("INSERT INTO PERSONALDETAILS (firstname,middlename,lastname) VALUES (%s, %s, %s)", (fname,mname,lname)) dbconnection.commit() While executing i am getting the following error cursor.execute("INSERT INTO PERSONALDETAILS(firstname,middlename,lastname) VALUES (%s, %s, %s)", (fname,mname,lname)) DatabaseError: ORA-01036: illegal variable name/number please solve this problem. regards Python Eager --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20060109/b52d89c9/attachment.html
|