Re: Strange string from MEMO field in FireBird

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



PHP Version 5.3.0alpha3-dev

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

Lester Caine pisze:
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.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux