#23099 [Com]: Problems at $result->fetchRow() on some tables
| From: | kancil at ww dot tu-berlin dot de | Date: | Tue, 08 Apr 2003 14:55:50 +0000 |
| Subject: | #23099 [Com]: Problems at $result->fetchRow() on some tables | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-15035@lists.php.net to get a copy of this message | ||
ID: 23099
Comment by: kancil at ww dot tu-berlin dot de
Reported By: hasihola at cs dot tu-berlin dot de
Status: Open
Bug Type: PEAR related
Operating System: Linux 2.4.7-10
PHP Version: 4.3.1
New Comment:
I Don't Think that this is PEAR related,
I Tried the newest PEAR packages on PHP 4.3.1 but it don't solve the
problem, i even tried to not use PEAR, but instead the normal interbase
functions.
But if i do SELECT COUNT (*) with the same 'where' expression
it results in N row's, but if i try to fetch it, it doesn't have any
content.
Previous Comments:
------------------------------------------------------------------------
[2003-04-07 14:21:52] hasihola at cs dot tu-berlin dot de
I just found that my scripts that are running without problems on php
4.2.3, got problem with some Tables on 4.3.1 (Interbase DB).
I'm doing select on a Table, but it returns no data here my test :
- (After Connecting) -
$result = $conn->query($sql);
if (DB::isError($result)){
echo "SELECT failed";
}
// it passes till here
if ( !($row = $result->fetchRow()) ){
echo "Table is filled but no results !!!";
// How could it be ?
}
This problem wasn't there in php 4.2.3, if I donwgrade the php then the
problem vanishes.
Here is my table :
TERMIN_NR (TERMINNR) SMALLINT Not Null
CHECK (VALUE > 0)
LEHRVERANSTALTUNGS_NR (LVNR) SMALLINT Not Null
CHECK (VALUE > 0)
SEMESTER (SEMESTER) CHAR(2) Not Null DEFAULT
'WS'
CHECK (VALUE IN ('WS', 'SS'))
ANFANGS_DATUM DATE Not Null
ENDE_DATUM DATE Not Null
PRUEFDATUM DATE Not Null
PRUEFTERMIN TIME Not Null
PRUEFUNGSART (PRUEFUNGSART) VARCHAR(18) Not Null
DEFAULT 'Klausur'
CHECK (VALUE IN ('Klausur','Prüfung',
'Rücksprache', 'Mündliche Prüfung'))
BETREUER (MITARBEITERNR) SMALLINT Not Null
CHECK (VALUE > 0)
ANMERKUNG VARCHAR(150) Nullable DEFAULT NULL
TERMIN_NUMMER INTEGER Nullable DEFAULT 0
CONSTRAINT INTEG_55:
Foreign key (LEHRVERANSTALTUNGS_NR) References LEHRVERANSTALTUNG
(LEHRVERANSTALTUNGS_NR)
CONSTRAINT INTEG_56:
Foreign key (BETREUER) References LEHRSTUHL_MITARBEITER
(MITARBEITER_NR)
CONSTRAINT INTEG_47:
Primary key (TERMIN_NR)
Triggers on Table ZEITRAUM:
SET_TERMIN_NR, Sequence: 0, Type: BEFORE INSERT, Active
I tried to figure out what's wrong, but no positive results !!!
thank's much
Jerry H
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=23099&edit=1