recordsets adding duplicate code

Hi,
Every time I add a recordset it is adding this code (see below) at the top of the page. Then without removing the duplicates the page is blank.

Any ideas ?, I deleted the prefs file and cache but no different. Should I do a fresh install of DW

Regards

Russ




function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . date("Y-m-d",strtotime($theValue)) . "'" : "NULL";
break;
case "time":
$theValue = ($theValue != "") ? "'" . date("H:i:s",strtotime($theValue)) . "'" : "NULL";
break;
case "datetime":
$theValue = ($theValue != "") ? "'" . date("Y-m-d H:i:s",strtotime($theValue)) . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

So you are getting the DW recordset function code duplicated with each recordset that you add to the page? I have not seen this issue before myself. Are you getting an error when you load the page after adding a second recordset?

I would hate to suggest to reinstall DW but this seems to be an odd issue. Has it always done this since you installed? If so re-installing might not solve the problem. I think you should look around in the Adobe forums to see if any others are experiencing this and what they have done to resolve it, I'm not familiar with the issue.

Hi Eric,

Yes that's exactly what is happening.
And explains some of the posts I made before about having blank pages, and the issues I was having with getting only 1 MRT to work on a page.

I don't think it did that at some point in the past.

I guess I shall try a fresh install

Regards

Russ

Hi,

After re installing and reactivating all my extensions the problem remained.
I then proceeded to remove and test one by one and found the culprit.
It was an extension I got from the Adobe site,

PHP MySQL Date Update 1.2 by Stretched Out Software, Inc (Mmm maybe I should have taken notice of the developers name)

If you use DW CS4, mac 10.6 DONT USE IT !

Regards
Russ

Great to hear you were able to figure out the issue. Its good to take notice on when extensions are installed so you will be able to track down certain issues like this one more easily. If you run into anything else, let us know.