Hi,
I am connecting to oracle8 database using Oracle8 Call-Interface (OCI8).
I want to use AbsolutePosition, RecordCount, PageSize etc properties of recordset in the same how we use in php with MYSQL.
My code goes as follows...
$database = "sms";
$user = "sms";
$pwd = "password";
// Connecting to Database
$conn = OCILogon($user, $pwd,$sid);
if($error = OCIError()) {
die("ERROR!! Couldn't connect to server!");
}
//getting To address from Contact table
$query = "select Contact_Email from Contact";
$stmt = OCIParse($conn, $query);
if($error = OCIError()) {
die("ERROR!! Statement syntax error!");
}
$result = OCIExecute($stmt);
$result->PageSize = 10;
$PageNo=1
if( $result->RecordCount > 0) {
$result->AbsolutePage = 1;
}
..........
but I am getting parse error at the statement where I am using these properties RecordCount, AbsolutePosition properties, anybosy can help me, pls it's very urgent.
Thanks in advance,
Sru
I am connecting to oracle8 database using Oracle8 Call-Interface (OCI8).
I want to use AbsolutePosition, RecordCount, PageSize etc properties of recordset in the same how we use in php with MYSQL.
My code goes as follows...
$database = "sms";
$user = "sms";
$pwd = "password";
// Connecting to Database
$conn = OCILogon($user, $pwd,$sid);
if($error = OCIError()) {
die("ERROR!! Couldn't connect to server!");
}
//getting To address from Contact table
$query = "select Contact_Email from Contact";
$stmt = OCIParse($conn, $query);
if($error = OCIError()) {
die("ERROR!! Statement syntax error!");
}
$result = OCIExecute($stmt);
$result->PageSize = 10;
$PageNo=1
if( $result->RecordCount > 0) {
$result->AbsolutePage = 1;
}
..........
but I am getting parse error at the statement where I am using these properties RecordCount, AbsolutePosition properties, anybosy can help me, pls it's very urgent.
Thanks in advance,
Sru