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
|