[web2py] Re: Blob field in legacy database

[Jose]

I solved this way

def padron():    
    registros = db(tb_padron).select(limitby=[0,30],orderby=tb_padron.nors)
    return dict(registros=registros)


def marca():   
    response.headers['Content-Type']='image/jpg'
    sql = "select first 1 marca from vwpadron where id=%s;"%request.args(0)
    registro = db.executesql(sql)
    return registro[0][0] 

in view:

<td>{{=IMG(_src=URL('default', 'marca', args=[r.id]), _width=130)}}</td>

Thanks
Jose