kamilwalas 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.
>
> PHP Version 5.3.0alpha3-dev

Windows or Linux?
64bit version?
We are not sure if all combinations of builds have actually had the
problem fixed.

> Source:
> $qry = ibase_query($database, $sql);
> $row = ibase_fetch_assoc($qry);

Try
CAST(list(distinct Y.DodatnieZlecenie) AS VARCHAR(1024) ) as
DodatnieZlecenia
This should prevent the 'memo' conversion.

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