Darryl VanDorp wrote:

>
> As for middleware, i'm developing some web stuff and
> am using ADODB and it doesn't seem to do anything
> special to extract blob's from simple select statments.
>

Hmmm. I'm not familiar with ADODB. However, I'd guess that you are using an
IB/Fb specific driver with it. That is the layer where the Blob API calls
should be implemented. Typically there should be a call(s) to make from ADODB
to specifically read each blob based on the blob id returned in the select
statement.

As a quick reality check I just tested the IBPhoenix ODBC driver via Borland's
SQL Explorer. It had no problem showing blobs in the blob window while I
scrolled through the dataset. I believe ADODB is a layer over ODBC so the
underlying technology should be there for you to read blobs fairly easily.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further