cur = con.cursor() cur.execute("SELECT ProjectId,ProjectName FROM Projects") data = row = cur.fetchall() projects_id = {} global projects projects = [] for i in data: projects.append(str(i[1])) projects_id[str(i[0])]=str(i[1]) #~ print data #~ print projects_id mypdfcreate = generate_pdf_file.create_pdf() class Example(wx.Frame): def __init__(self, *args, **kw): super(Example, self).__init__(*args, **kw) self.InitUI() global projects def InitUI(self): pnl = wx.Panel(self)
cur.execute("SELECT ProjectId,ProjectName FROM Projects") data = row = cur.fetchall() project_data = [] projects_id = {} projects = [] for i in data: projects.append(str(i[1])) projects_id[str(i[0])]=str(i[1]) #~ print data #~ print projects_id mypdfcreate = generate_pdf_file.create_pdf() myHTML = "" htmlAppend = """ <p><br> </p> </body> </html>""" class AboutDlg(wx.Frame): def __init__(self, parent): wx.Frame.__init__(self, parent, wx.ID_ANY, title="About", size=(900,1000))