0

I built a function as following

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 ('Y','y')) ''' % vars()
     try:
        cursor.execute( sql )
        noduplicates = cursor2.fetchall();
     except:
        noduplicates = [('None')]
     
     cursor.close()
     db.close()
     return

### later on, it was called by followiging code:
isExists(fxfcustid)
       if noduplicates != 0:
           print mainscreen(empno,'This customer has been entered. Request failed',0,'')         
      else:
        cursor.execute(insertSql % vars())

But it doesn't work. what's wrong with this code? is noduplicates number or string? any help is highly appreciated.

Thanks,

Jackie

Edit: code tags added by vegaseat

2
Contributors
1
Reply
3
Views
12 Years
Discussion Span
Last Post by xav.vijay
0

Well jchang, I am not exacly sure where the problem is ,but can u check on the following syntax in your code... Hope it helps

In the main code where u call this function

isExists(fxfcustid) is actually supposed to be "IsExists(fxfcustid)"
functions are case sensitive...But if you are not facing a problem here, maybe the next one could be bothering...

I have never used three ' ' ' ( and I have no idea how it works)
In your code

sql = '''select count(*)
from triumph.fxf_salescontest_entry
where fxf_acct_nbr = %(fxfcustid)s)
and (delete_flag is null or
delete_flag not in ('Y','y')) ''' % vars()


Here 'fxcustid' seems to be caught within the string, I mean it has become a part of the string... why dont u try

sql = "select count(*) from triumph.fxf_salescontest_entry where fxf_acct_nbr = %(" + fxfcustid + ")s) and (delete_flag is null or delete_flag not in ('Y','y'))" % vars()

I have very little knowledge in SQL Queries, I dont know whether the above syntax is right, hope it helps you in some way...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.