> 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

no no no....
I have my own content management system using firebird and blobs and there
is no such requirement. You may select the blob and response.write it's
contents - that's it.
Alan