Subject Using Firebird BLOBs with ASP to deliver web pages
Author henrya2468
I would appreciate confirmation of the following and any relevant
advice/pointers:

We are planning to set up a website on a Windows 2000 Server system
which uses ASP to access and deliver web pages stored in a Firebird
database. The content of each web page is to be stored in one or more
BLOBs as the size may exceed that of VARCHAR fields and we also need
to store binary information, e.g. pictures, pdfs, and word-processing
docs.

Having looked at documentation on the Firebird site, Helen's book, and
searched the support mail it appears that a SQL query or stored
procedure will return the BLOB id but that we will need to develop a
UDF to retrieve the BLOB content and write it to a file which the ASP
scripts will deliver to the requesting browser. This UDF may be called
as part of a stored procedure.

Is this correct? Are there any UDFs which cover this functionality
under the same licence as Firebird itself?

My apologies if this has all been covered before, in which case would
you mind pointing me in the right direction.

Many thanks,
Henry