[mod_python] error while inserting data

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


More information about the Mod_python mailing list