|
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
|