Did you read about upload type field? http://web2py.com/books/default/chapter/29/7#SQLFORM-and-uploads
Richard On Wed, Jul 4, 2012 at 10:48 AM, Jose <[email protected]> wrote: > Hello > > I have a database working with another system. I need to create some > reports and I'm doing with web2py. > > Simplifying model is as follows: > > tb_padron = db.define_table('vwpadron', > Field('nors'), > Field("marca", "blob"), > Field("archivoimagen", "upload", uploadfield="marca"), > migrate=False > ) > > field "marca" stores an image as blob type. > > if I access from outside web2py: > > cur = conn.cursor() > cur.execute("select marca from vwpadron where id=15;") > print cur.fetchall() > > get (truncated for clarity): > > [['\xff\xd8\xff\xe0\x00\x10JFIF\x00\x01\x0...]] > > obtained using the string in a controller function > > def test_image(): > img='\xff\xd8\xff\xe0\x00\x10JFIF\...' > response.headers['Content-Type']='image/jpg' > return img > > I see the image correctly. > > > Now if I do the following: > > def image2(): > marca = db(tb_padron.id==15).select(tb_padron.marca).first() > return dict(marca=marca) > > in view image2: > > {{extend 'layout.html'}} > {{=marca.marca}} > > get: > > $R �5�=�m��P j��Gv�㞻�Ѓ Q� ��QU�a� y�!�;-��1�9�W�"�����������;���� > 6�j��E�R�JSϟ���Gi; �_AU|Z�9�Uh�[�b���!��� ��R�J�F��L)��_�� ��#@�(�#4�'ʍ6+ > �U > > > In another attempt: > > def imagen3(): > marca = db.executesql("select marca from vwpadron where id=15;") > return dict(marca=marca) > > get (truncated for clarity): > > [['\xff\xd8\xff\xe0\x00\x10JFIF\x00\x01\...']] > > if I do the following: > return dict(marca=marca[0][0]) > > wanting to get: '\xff\xd8\xff\xe0\x00\x10JFIF\x00\x01\...' > > but no, I get something else and I can not show as an image. > > ���� JFIF ��C $.' ",# (7),01444 '9=82<.342�� ` �� ��� } !1A Qa "q 2��� > #B�� R��$3br� ... > > > Someone can help me with this. Encodings is a problem? > > (I wonder if you understand?) > > regards > Jose > >
