Embedded OLE PDF

[aburningflame]

Re: Embedded OLE PDF

But the only OLE object I see in Alpha is an OLE BMP. (which doesn't work.)
Is it possible to view this data in A5 or do I have to extract it into a PDF file.

Are you trying to show the pdf on a grid? in a page? Are you trying to make the file available for download? Are there security concerns?
What exactly are you trying to do?

If youre storing the raw bytes, thats fine. But you need a page to serve those raw bytes to an object tag (if you want to display the actual pdf in the browser)

You can try using the object tag with an embed fallback and provide a "server" page (in the sense that the page serves content, not in the sense that the page resides on the server) that sets the mime type provides the bytes.


<object data="getPDFFile.a5w?document_id=<%a5 ?document_id %>" type="application/pdf" width="100%" height="100%">
<embed></embed> //go lookup the embed tag
</object>

The getPDFFile.a5w would do something like
'connect to the database
'verify permissions
'if permission is granted - output the pdf bytes
You might have to use
header('Mime-Type: application/pdf'); (Go do some digging) and then
response.readfile(fileBytes)


Heres an example with an image file:
serve_image.a5w

dim x_id as N
	dim conn as SQL::Connection
	dim sql as C=""
	dim args as SQL::Arguments
	dim type as C="thumbnail"

	if eval_valid("Request.Variables.aid") then
		args.set("aid",Request.Variables.aid)
		if conn.open("::name::conn") then
			sql="SELECT * FROM x WHERE x_id=:aid"
			if conn.execute(sql,args) then
				dim filename as C
				if type=="thumbnail" then
					filename=conn.ResultSet.data("x_thumbnail")
				else
					filename=conn.ResultSet.data("x_filename")
				end if
				if file.exists(filename) then
					?file.to_blob(filename)
				end if
			end if
			conn.close()
		end if
	end if

Another page / Freeform HTML field on a dialog / Freeform HTML field on a grid / whatever else you want

<%a5
	?"<img height=100 src=\"handlers/serve_image.a5w?aid="+Request.Variables.aid+"\" />"
%>

[lgrupido]

Re: Embedded OLE PDF

That is normally how I would do it too, but it's an import of someone else's data.

I'll work around it instead, thanks.

[aburningflame]

Re: Embedded OLE PDF

Personally, we dont store blobs in the database.
We store files in the file system and store the fullpath in the DB.

THats probably your best bet

[lgrupido]

I have a table that was converted from Access to MS SQL. In this table is a field with an embedded PDF.

How can I display the embedded PDF? In Access it is an OLE Object.

But the only OLE object I see in Alpha is an OLE BMP. (which doesn't work.)

Is it possible to view this data in A5 or do I have to extract it into a PDF file.