No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
I built a function as following [code] def IsExists(fxfcustid): #global noduplicates db = db_connect("triumph","freight","vcpdb") cursor = db2.cursor() #************************************************************************* #*** Query to get entries made by the person acessing the system *** #************************************************************************* sql = '''select count(*) from triumph.fxf_salescontest_entry where fxf_acct_nbr = %(fxfcustid)s) and (delete_flag is null or delete_flag not in …
Dear Python Gurus: I am a very new Python user, would really appreciate your help. I used Python to write a web form for users to enter. The underlined database is Oracle. One validation needs to enforce to eliminate duplicates entries. For example: one customer ID can only be entered …
The End.