sqlite3 and tableView

giuseppeporro · July 16, 2013, 5:47pm

build 2013.1137

Hello everybody,

I’m newbie and I trying to import data in (myList = tableView.newList).

This code works fine

data[1] = {} data[1].title = "Title 1" data[1].image = "myImage1.png" &nbsp;&nbsp; &nbsp; data[2] = {} data[2].title = "Title2" data[2].image = "myImage2.png" &nbsp; myList = tableView.newList &nbsp;&nbsp; &nbsp;{ &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;data = data, &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;default="listItemBg.png", &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;over="listItemBg\_over.png", &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;onRelease=listButtonRelease, &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;callback=function(item) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; local g = display.newGroup() &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; local img = display.newImage(item.image) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; g:insert(img) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; img.x = math.floor(img.width\*0.5 + 6) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; img.y = math.floor(img.height\*0.5) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; local t = display.newText(item.title, 0, 0, native.systemFontBold, 16) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; g:insert(t) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; t:setTextColor(0, 0, 0) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; t.x = math.floor(t.width/2) + 160 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; t.y = 46 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; return g &nbsp;&nbsp;&nbsp; end }

If I import data from DB like this, I just have the title, but not the image

local data = {} local i = 1 for row in db:nrows(sql) do &nbsp;&nbsp; &nbsp;data[i] = row.title &nbsp;&nbsp; &nbsp;data[i] = row.image &nbsp;&nbsp; &nbsp;i = i + 1 end myList = tableView.newList{ data=data, default="listItemBg.png", over="listItemBg\_over.png", onRelease=listButtonRelease, callback=function(row) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;local t = display.newText(row, 0, 0, native.systemFontBold, 16) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;t:setTextColor(0, 0, 0) &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;t.x = math.floor(t.width/2) + 12 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;t.y = 46 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;return t &nbsp;&nbsp; &nbsp;end }

any help would be appreciated.

thanks

Giuseppe