ora_numrow

[Elknox]

the ora_numrows always returns 1, is there a way of getting the correct number of rows?

[jweissig]

Hi,

Can you please explain the contect in which you are using "ora_numrows"? You should note that this function acts more as a counter of the number of rows fetched from the cursor. If you execute this prior to processing the cursor you will always get a 0 for an answer.

• Justin

[Elknox]

Here is part of the code I am using and the result I get.
//**********Code

$result = Ora_Parse ($cursor, $query);
if ($result == false){
echo Ora_ErrorCode($cursor) . ": " . Ora_Error($cursor)."<BR>";
exit;
}
$result = Ora_Exec ($cursor);
if ($result == false){
echo Ora_ErrorCode($cursor) . ": " . Ora_Error($cursor)."<BR>";
exit;
}
if (Ora_Fetch_Into ($cursor, &$values)){

$rowtotal = ora_numrow($cursor);
echo"Total Rows affected equals $rowtotal";
//// -- other details --
}
//*************Result
Total Rows affected equals 1

[jweissig]

hi,

what should this number be? Like what are you expecting to have for a result? What is the SQL statment that you are running on the server, and how many row's are updated?

• Justin

[Elknox]

$query = ("SELECT * FROM tblLibrarySymbols WHERE LibrarySymbol LIKE '$txtSearch%'");

of which $txtSearch is a text box.

I am expecting at least 10 row reurned for each search.

Elknox