[mod_python] facing sql error

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


More information about the Mod_python mailing list