python eager
python_eager at yahoo.com
Mon Jan 9 05:19:05 EST 2006
Hi 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! DSL Something to write home about. Just $16.99/mo. or less -------------- next part -------------- An HTML attachment was scrubbed... URL: http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20060109/bff66b45/attachment.html
|