Hi,

> 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.

An UDF cannot call back to a database.

That being said, you're query components/drivers will return the blob
just fine. There's no need to jump through hoops to get your blob content.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com