Hi John,
your first example looks right. Can you send us the code you use to list
the records. I would expect the problem in there, because in your second
example basically the FetchStatement is not doing anything as the
statement has not been executed.
You need to loop through the result set array differntly after the
FetchStatement, then looping through the results without exec.
BTW: I had performance drops with the FetchStatement.
Florian
Von:
"Asendorf, John" <[EMAIL PROTECTED]>
Mi
20:35
Betreff:
Oracle record counting
An:
"Php-Windows (E-mail)" <[EMAIL PROTECTED]>
I'm attempting to work on a little oracle search...
My problem is that if I put the OCIExecute BEFORE the OCIFetchStatement
line, I get one error ( Warning: OCIFetchInto: ORA-01002: fetch out of
sequence in d:\InetPub\wwwroot\etc. ) but if I put OCIExecute AFTER the
OCIFetchStatement I get a different error (Warning: OCIFetchStatement:
ORA-24338: statement handle not executed in ).
In this order:
OCIExecute ( $stmt_search , OCI_DEFAULT );
$nrows = OCIFetchStatement( $stmt_search , $results );
echo "<P>There are $nrows records containing your criteria.</P>";
I get the number of records, but the I don't get the reords listed.
In this order:
$nrows = OCIFetchStatement( $stmt_search , $results );
echo "<P>There are $nrows records containing your criteria.</P>";
OCIExecute ( $stmt_search , OCI_DEFAULT );
I get the list of records, but no amount of records... I tried running
a
reset( $results); on it but that didn't seem to help...
Can someone help? Oracle 8.1.6 client (7.3.4 server) NT4 IIS4 PHP 4.0.4
CGI
Thanks,
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Aut insanit homo, aut versus facit
--
Florian Clever
[EMAIL PROTECTED]
http://www.Clever-Software-Solutions.de/
PGP Key @ ldap://certserver.pgp.net/
"Always listen to experts. They'll tell you what can't be done, and why.
Then do it. " -- Robert A. Heinlein
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
