[mod_python] reg delete the records

python eager python_eager at yahoo.com
Wed Feb 1 01:56:33 EST 2006


Hi, This my code snippet.
  I am deleting records. But the sql statment working fine. but it will not delete. i have two files. one is db_connection, and other one is PerDetailsDAO.
   
  i am creating object in PerDetailsDAO for db_connection.py
  Thereafter executing the sql statement.
  But the particular record will not deleted.
  What is the error?
  Please rectify the problem
  Thank you
   
   
  File Name : db_connection.py
   
  import cx_Oracle
class db_connection:
     def getConnection(self):
        dbconnection = cx_Oracle.connect("username", "password", "hoststring")
        cursor = dbconnection.cursor()
        cursor.arraysize = 50
        return cursor 
   
    File Name : PerDetailsDAO.py
   

  class PerDetailsDAO:
     def delete(self,pid):
        con = db_connection()
        cursor = con.getConnection()
        sql = "DELETE FROM PERSONALDETAILS WHERE PID =100"
        cursor.execute(sql)

  regards
  Python Eager
   

		
---------------------------------
Do you Yahoo!?
 With a free 1 GB, there's more in store with Yahoo! Mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20060131/b76f923a/attachment.html


More information about the Mod_python mailing list