[Cs-webapplibs-commits] SF.net SVN: cs-webapplibs:[208] trunk/0.4/db_types/cs_phpDB__pgsql.class. php

[<cra...@us...>]

Revision: 208
          http://cs-webapplibs.svn.sourceforge.net/cs-webapplibs/?rev=208&view=rev
Author:   crazedsanity
Date:     2011-02-07 19:47:25 +0000 (Mon, 07 Feb 2011)

Log Message:
-----------
Minor changes so the last query doesn't get overwritten by currval queries.

/db_types/cs_phpDB__pgsql.class.php:
	* connect():
		-- slightly better exception message...
	* exec():
		-- ARG CHANGE: NEW ARG: #2 ($setLastQuery=true)
		-- optionally NOT set lastQuery var.
	* get_currval():
		-- pass false as the second argument to exec() so it doesn't get set 
		as the lastQuery.

Modified Paths:
--------------
    trunk/0.4/db_types/cs_phpDB__pgsql.class.php

Modified: trunk/0.4/db_types/cs_phpDB__pgsql.class.php
===================================================================
--- trunk/0.4/db_types/cs_phpDB__pgsql.class.php	2011-02-07 19:37:12 UTC (rev 207)
+++ trunk/0.4/db_types/cs_phpDB__pgsql.class.php	2011-02-07 19:47:25 UTC (rev 208)
@@ -201,7 +201,7 @@
 			}
 		}
 		else {
-			throw new exception(__METHOD__ .": paramsAreSet=(". $this->paramsAreSet ."), isConnected=(". $this->isConnected .")");
+			throw new exception(__METHOD__ .": not connected... paramsAreSet=(". $this->paramsAreSet ."), isConnected=(". $this->isConnected .")");
 		}
 		
 		return($retval);
@@ -225,8 +225,10 @@
 	 * 
 	 * TODO: re-implement query logging (setting debug, logfilename, etc).
 	 */
-	function exec($query) {
-		$this->lastQuery = $query;
+	function exec($query,$setLastQuery=true) {
+		if($setLastQuery) {
+			$this->lastQuery = $query;
+		}
 		if($this->useQueryList) {
 			$this->queryList[] = $query;
 		}
@@ -1095,7 +1097,7 @@
 	//=========================================================================
 	public function get_currval($sequence) {
 		if(is_string($sequence) && strlen($sequence) >= 5) {
-			$numrows = $this->exec("SELECT currval('". $sequence ."')");
+			$numrows = $this->exec("SELECT currval('". $sequence ."')",false);
 			$dberror = $this->errorMsg();
 			
 			if($numrows == 1 && !strlen($dberror)) {


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.