How are you using this in web2py (i.e., where/how does get_GetEmployeeID get called)? Do you get any errors? When you run the web2py shell, how are you starting it, and are you using the same Python interpreter as when you use the basic Python shell?
Also, is the only difference between your two classes the hard-coded database connection string? If so, why not using a single class and just make the connection string an argument of the __init__ function? Anthony On Wednesday, August 5, 2015 at 4:17:04 PM UTC-4, David wrote: > > Here is the first part of the module I was reffering to: > > import pymssql > > > class HR_DB(): > def __init__(self): > self.conn = pymssql.connect(DB Connection Info Removed) > > def Execute(self, statement,*args): > cursor = self.conn.cursor() > cursor.execute(statement, args) > result = cursor.fetchall() > cursor.close() > return result > > def DestroyConnection(self): > self.conn.close() > > class Coll_DB(): > def __init__(self): > self.conn = pymssql.connect(DB Connection Info Removed) > > def Execute(self, statement, *args): > cursor = self.conn.cursor() > cursor.execute(statement,args) > result = cursor.fetchall() > cursor.close() > return result > > def DestroyConnection(self): > self.conn.close() > > def get_GetEmployeeID(SamAccountName): > > conn = Coll_DB() > rows = conn.Execute(SQL Removed) > if len(rows) > 0: > return(rows[0]['collid']) > conn.DestroyConnection() > > > > > Again this works just fine calling it outside of web2py. > > if I run it from the interpreter on the server I am getting the correct id > number. Even using the shell in web2py and issuing the same commands I am > getting nothing. I feel like I am missing something simple > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
