here's another beauty to think about:
var $metaColumnsSQL = "select lower(a.rdb\$field_name), a.rdb\$null_flag,
a.rdb\$default_source, b.rdb\$field_length, b.rdb\$field_scale,
b.rdb\$field_sub_type, b.rdb\$field_precision, b.rdb\$field_type from
rdb\$relation_fields a, rdb\$fields b where a.rdb\$field_source =
b.rdb\$field_name and a.rdb\$relation_name = '%s' order by
a.rdb\$field_position asc";

this fails really stupidly since
&MetaColumns uses
$rs = $this->Execute(sprintf($this->metaColumnsSQL,strtoupper($table)));
and doesn't obey the ADODB_ASSOC_CASE define

plus in flyspray - don't use a drive:path\filename.fdb for the database,
setup an alias, the upgrade process can't handle the \ backslashes... it
tries to re-write the config over and over til you have a database name
which it too long with hundreds of backslashes...

Alan

> -----Original Message-----
> From: firebird-php@yahoogroups.com
> [mailto:firebird-php@yahoogroups.com]On Behalf Of Lester Caine
> Sent: Tuesday, 12 June 2007 9:05 PM
> To: firebird-php@yahoogroups.com
> Subject: Re: [firebird-php] FireBird/ADODB
>
>
> Alan McDonald wrote:
> >> The ONLY way to use blob's is via param's in the querys. If they
> >> are simply
> >> trying to read the blob data direct from the SQL it will not work :(
> >>
> >> --
> >> Lester Caine - G8HFL
> >
> > hang on - I can understand the update/insert use of params but
> why can't you
> > just read blob data? I do that all the time.
>
> Pear-DB simply returns the Bolb ID it does not return the
> content. ADOdb I
> always see the content, but I never looked under the hood to
> confirm how :(
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
> L.S.Caine Electronic Services - http://home.lsces.co.uk
> MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
> Firebird Foundation Inc. - http://www.firebirdsql.org/index.php
>
>
>
> Yahoo! Groups Links
>
>
>
>