Python

Python RSS

Function calling- numeric or char

Please support our Python advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Sep 2005

Posts: 2

Reputation: jchang is an unknown quantity at this point

Solved Threads: 0

jchang

Offline

Newbie Poster

Function calling- numeric or char

Sep 29th, 2005

I built a function as following

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
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())
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

•

Join Date: Aug 2005

Posts: 46

Reputation: xav.vijay is an unknown quantity at this point

Solved Threads: 6

xav.vijay

Offline

Light Poster

Re: Function calling- numeric or char

Oct 8th, 2005

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