At 09:33 AM 12/6/2004, Martijn Tonies wrote:

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

Actually UDFs and blob retrieval work pretty well together, once
you've got the blob id out of the database. Your absolutely right
though, that almost every component has some mechanism for
retrieving blob data and using the components is easier than a
UDF. There's also a routine called BLOB_dump that dumps to files.

Rega