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 -- http://mail.python.org/mailman/listinfo/python-list