ADODB (http://php.weblogs.com/ADODB/)
is a php based DB abstraction layer.
Since php has different implentations for each
database ADODB (as is phplib) gives a common
interface to allow cross db portability as well
as 1 learning curve.

What your saying is ADODB would have to be
made smart enough to take a select statment,
determine which columns are blob's and process them
as appropriate. (which i dont' think it is now)

Correct?


-D


-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Thursday, October 04, 2001 10:31 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Equivalent to TEXT field


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



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/