Re: [PHP-DB] Strange string from MEMO field in FireBird
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:
0x000c, 0x0019, 0x0014, 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) 0x000c
[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
[PHP-DB] Strange string from MEMO field in FireBird
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:
0x000c, 0x0019, 0x0014, 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) 0x000c
[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.
Kamil Walas.
P.S. Sorry for my English.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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:
0x000c, 0x0019, 0x0014, 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) 0x000c
[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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
