debugSQL(); for update query

Hello,

I am unable to find debugSQL(); for update query.

However, it works with "RecordSet"

>> echo $RecordSet->debugSQL(); // works good
>> echo $UpdateQuery->debugSQL(); // DOES NOT WORK?

Please see if you can help.
Regards

That function isn't currently available for the query object class. They are so similar, that it might work if you just copied the debugSQL function from the rsobj.php file and pasted it into the queryobj.php file.

Originally Said By: Ray Borduin

  That function isn't currently available for the query object class. They are so similar, that it might work if you just copied the debugSQL function from the rsobj.php file and pasted it into the queryobj.php file.  

Please advice. I get following error when i echo >>

echo $UpdateQuery->debugSQL();

Error: Warning: substr() expects parameter 1 to be string, array given in {filePath}\queryobj.php on line 227


Content of link 227 is " $thisType = substr($paramTypes,$x,1); "


Thank you once again.


FULL CODE IS BELOW:

// ps_com starts
public function debugSQL() {
$debugStatement = $this->Statement;
$paramTypes = $this->ParamTypes;
for ($x=0; $x<sizeof($this->ParamValues); $x++) {
$pos = strpos($debugStatement,"?");
$thisType = substr($paramTypes,$x,1);
if ($pos !== false) {
$debugStatement = substr_replace($debugStatement,(($thisType=="s")?"'":"") . $this->ParamValues[$x] . (($thisType=="s")?"'":""),$pos,strlen("?"));
}
}
return $debugStatement;
}

// ps_com ends

Change the line:
$thisType = substr($paramTypes,$x,1);

To:
$thisType = $paramTypes[$x];

Appreciated. It's working..

thanks and have a good time..