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