Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.0

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)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 19 + 16 = ?

 
 [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-01 18:55 UTC] jens dot knoop at antwerpes dot de
wrong category :o)
 [2004-03-12 03:04 UTC] danielc
Good point. Fixed in CVS. Will have a new release out shortly too. Thanks.