I have this code that shows a PDF stored in a field "archivopdf" of table "facturas". It is embedded in an iframe
request.args(0) has the primary key def facturasprevista(): facturas=db.facturas[request.args(0)] response.headers['Content-Type']='application/pdf' return facturas.archivopdf On Monday, February 26, 2018 at 12:35:14 AM UTC-7, mweissen wrote: > > Did not solve the problem. The pdf data is stored in the table (it can be > retrieved manually). > The question is how to show the pdf in an iframe or an embed field. > > 2018-02-26 8:00 GMT+01:00 Marco Mansilla <thebig...@gmail.com > <javascript:>>: > >> Take a look to this >> >> https://groups.google.com/forum/m/#!topic/web2py/qgmh5C0XXkY >> >> El 26 feb. 2018 03:36, "Martin Weissenboeck" <mwei...@gmail.com >> <javascript:>> escribió: >> >>> Sorry, it does not work. >>> The same results with or without "default" >>> >>> 2018-02-26 4:20 GMT+01:00 Marco Mansilla <thebig...@gmail.com >>> <javascript:>>: >>> >>>> This >>>> >>>> download = URL("download", args=p.pdf) >>>> >>>> Should be >>>> >>>> download = URL("default", "download", args=p.pdf) >>>> >>>> You can do that on the view. But the change on the controller should do. >>>> >>>> El 25 feb. 2018 15:54, "Martin Weissenboeck" <mwei...@gmail.com >>>> <javascript:>> escribió: >>>> >>>> What I want to do: >>>> >>>> I store a pdf-file in a database table. >>>> Then I want to show this file. >>>> >>>> The model: >>>> >>>> db.define_table("pdfs", >>>> Field("pdf", "upload", uploadfield="pdfdata"), >>>> Field("description", "text"), >>>> Field("pdfdata","blob") >>>> ) >>>> >>>> >>>> >>>> The controller: >>>> >>>> def showpdf(): >>>> id = int(request.args[0]) >>>> p=db.pdfs(id) >>>> download = URL("download", args=p.pdf) >>>> return dict(p=p, download=download) >>>> >>>> >>>> >>>> The view: >>>> >>>> {{extend 'layout.html'}} >>>> Description: {{=p.description}} >>>> <br/> >>>> <embed src="{{=download}}" type="application/pdf"> >>>> <div> >>>> Cannot display embed >>>> </div> >>>> </embed> >>>> <br/><br/> >>>> <iframe src="{{=download}}" type="application/pdf"> >>>> <div> >>>> Cannot display iframe >>>> </div> >>>> </iframe> >>>> >>>> >>>> >>>> The <embed> section show an error "Error on loading pdf". >>>> >>>> The <iframe> section shows an empty iframe and opens the Adobe Acrobat >>>> Reader with the required pdf. >>>> >>>> Any ideas? >>>> >>>> Regards Martin >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com <javascript:>. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com <javascript:>. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "web2py-users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to web2py+un...@googlegroups.com <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.