wxchoice appenitems not working

[dolamitejenkins]

When I try to "append" the rows returned to the widget only one row is shown and when i try to "append items" to the widget only one row is shown and it is shown as a column ... what am I doing wrong ???

Code: Select all

self.weather2 = wx.Choice(self.panel, wx.ID_ANY, choices = self.nameofevet1, name='ShowList')
	self.populateVenue(self)

def populateVenue(self,event):
	conn = lite.connect("PermPatRecord.sqlite")
        c = conn.cursor()
        c.execute('select * from showlist')
	rows=c.fetchall()
            
	rRows=[]
	for row in rows:
                s={}
                s['Venue_name']  =row[1] 
		
		self.nameofevet1 = s['Venue_name']
		print self.nameofevet1
		
	self.weather2.Clear()
	self.weather2.AppendItems(self.nameofevet1)
	
    

[doublemax]

I don't know Python too well, but this line seems wrong:

Code: Select all

self.nameofevet1 = s['Venue_name']

I don't know what type nameofevet1 is, but if it's some kind of list, you have to append the current item instead of just assigning it.

[dolamitejenkins]

reworked the querry to make sure I get a list and still not working correctly it only appends the last item in the list

Code: Select all

conn = lite.connect("C:\Python26\sign1\VenueShow\PermPatRecord.sqlite")
	with conn:
	    conn.row_factory = lite.Row
	    c = conn.cursor()
	    c.execute('select * from showlist')
	    rows=c.fetchall()
	    for row in rows:
		self.nameofevet1= row[1]
		self.weather2.Clear()
		self.weather2.Append(self.nameofevet1)

[doublemax]

Remove this line:

Code: Select all

self.weather2.Clear()