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