Ralf wrote:
Is their anybody with xperience in using the both and can provide me with
some xamples.
Thx a lot
Ralf
I suggest you buy the book from Mark Hammond
hg
ex (major cut and paste):
#************************************************* *******************
def Get_User_Info_From_DB(self, p_user_id):
try:
#l_query = 'Select Groups.GR_AccessDate from Groups,Members
where Members.GroupId = Groups.GR_GroupId and Members.MemberId = %s;' %
p_user_id
l_query = 'SELECT
Firstname,Lastname,GR_ExpirationDate,GR_AccessDate ,GR_CurrentBal,MemberType,MemberDues
FROM MemberTypes,Members,Groups Where (Groups.GR_GroupId =
Members.GroupId) and (MemberTypes.MemberTypeID =
Groups.GR_MembershipType) and (MemberId = %s);' % p_user_id
l_conn = win32com.client.Dispatch(r'ADODB.Connection')
l_DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE='+self.__m_database + ';'
l_conn.Open(l_DSN)
l_recordset = win32com.client.Dispatch(r'ADODB.Recordset')
l_recordset.Open(l_query, l_conn, 1, 3)
l_found_date = False
try:
l_recordset.MoveFirst()
l_exp_date =
l_recordset.Fields.Item('GR_ExpirationDate').Value
l_access_date =
l_recordset.Fields.Item('GR_AccessDate').Value
l_last_name = l_recordset.Fields.Item('Lastname').Value
l_first_name = l_recordset.Fields.Item('Firstname').Value
l_membership_type =
l_recordset.Fields.Item('MemberType').Value
#print 'HERE ', l_recordset.Fields.Item('MemberType').Value
l_val = l_recordset.Fields.Item('MemberDues').Value
l_dues_amount = '%.02f' % (float(l_val[1])/10000.0)
if None == l_access_date:
self.__m_log.Log( ('DATE IS NOT AVAILABLE FOR USER
ID %s' % p_user_id) )
else:
l_found_date = True
self.__m_log.Log( ('FOUND NEW DATE IN DATABASE FOR
USER ID %s: %s' % (p_user_id, l_access_date)) )
except:
self.__m_log.Log( ( 'GET DATE QUERY FAILED ON USER ID
%s' % p_user_id) )
self.__m_log.Log(traceback.format_exc())
l_conn.Close()
if False == l_found_date:
return None
#print 'IN GET: ACCESS ', l_access_date.Format()
#print 'IN GET: EXP', l_exp_date.Format()
return ( l_exp_date.Format(),l_access_date.Format(),
l_last_name, l_first_name, l_membership_type, l_dues_amount)
except:
self.__m_log.Log(traceback.format_exc())
try:
l_conn.Close()
except:
self.__m_log.Log('Could not close database connection on
retrieval')
self.__m_log.Log(traceback.format_exc())
pass
self.__m_log.Log( ('Fatal error retrieving date from
database for user id %s ' % p_user_id))
return None
