| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.2 |
| Bug #930 | missing bind-var support in DB oci-numRows-function | ||
|---|---|---|---|
| Submitted: | 2004-03-01 18:45 UTC | ||
| From: | jens dot knoop at antwerpes dot de | Assigned: | danielc |
| Status: | Closed | Package: | DB |
| PHP Version: | Irrelevant | OS: | linux |
| Roadmaps: | (Not assigned) | ||
[2004-03-01 18:45 UTC] jens dot knoop at antwerpes dot de
Description:
------------
db oci function "numRows" doesn't support querys with bind-vars.
Reproduce code:
---------------
var $last_data = array() ;
function &execute($stmt, $data = array()) {
...
$this->last_data = $data ;
...
}
function numRows($result) {
....
$countquery = 'SELECT COUNT(*) FROM ('.$this->last_query.')';
//
if( $this->last_data ) {
$objStm = $this->prepare($countquery) ;
$count =& $this->execute($objStm, $this->last_data ) ;
}
else {
$save_query = $this->last_query;
$save_stmt = $this->last_stmt;
$count =& $this->query($countquery);
}
...
}
Comments
[2004-03-12 03:04 UTC] danielc
Good point. Fixed in CVS. Will have a new release out shortly too. Thanks.