Re: [PHP-DB] Strange string from MEMO field in FireBird

Kamil Walas wrote:
> Hi,
> 
> I new in PHP. I work with FireBird and I have query looks:
> "select Y.Organizm as Nazwa, count(Y.ID) as LiczbaPrzypadkow, 
> count(Y.Organizm) as DodatnichPrzypadkow, count(distinct Y.Pacjent) as 
> LiczbaPacjentow, count(distinct Y.DodatniPacjent) as DodatnichPacjentow 
> , list(distinct Y.DodatnieZlecenie) as DodatnieZlecenia from 
> SelRaportIdentyfikacji('2008-11-01', '2008-11-30') Y left outer join 
> Materialy M on M.ID = Y.Material left outer join Oddzialy O on O.ID = 
> Y.Oddzial group by 1 order by 3 desc, 1"
> 
> and the result is something like that:
> http://img509.imageshack.us/img509/5066/78994034sy1.jpg
> 
> when I double-click on the MEMO field I get window with ID:
> http://img300.imageshack.us/img300/623/79032822pi4.jpg
> 
> it looks that everything is OK.
> 
> But when I write in php  echo $row['DODATNIEZLECENIA'] I got values like:
> 0x0000000c00000000, 0x0000001900000000, 0x0000001400000000, itp..
> 
> var_dump($row) gives:
> array(8) { ["NAZWA"]=>  string(16) "Escherichia coli" 
> ["LICZBAPRZYPADKOW"]=>  int(42) ["DODATNICHPRZYPADKOW"]=>  int(42) 
> ["LICZBAPACJENTOW"]=>  int(41) ["DODATNICHPACJENTOW"]=>  int(41) 
> ["DODATNIEZLECENIA"]=>  string(18) "0x0000000c00000000" 
> ["NAZWAGRUPY1"]=>  string(14) "(nieokreślony)" ["NAZWAGRUPY2"]=> 
> string(14) "(nieokreślony)" }
> 
> I don't know what I'm doing wrong. Why php didn't write correctly 
> exactly this one field? Any help will be aprrecieated.

You do not say which version of PHP. There was a problem with versions
of PHP5 from 5.2.0 to 5.2 5 which return the BLOB ID incorrectly. 5.2.6
should be OK. Also you do not say how you are creating the results.
Which functions you are using.

There is a support list for Firebird and PHP
http://groups.yahoo.com/group/firebird-php/ which also has useful
messages in the archive.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php