Strange PHP code generated

> Well after wasting a day I found that this block of code keeps getting
> added
> whenever I touch a recordset (open and close it for example). For
> whatever
> reason this is causing my page to display a blank page each time DW adds
> another repetition. I then go in and delete it and alas my page works
> again.
> This must be a bug and I'm not sure why I am just now seeing my pages not
> display. For those looking at this, here is the code that I have to keep
> removing:

I think you're slowly learning why not to depend on software to write code
for you. ;o)

-Darrel

"davidbarrackphoto" <webforumsuser@macromedia.com> wrote in message
news:fhi8d8$8h$1@forums.macromedia.com...
> Well after wasting a day I found that this block of code keeps getting
> added
> whenever I touch a recordset (open and close it for example). For
> whatever
> reason this is causing my page to display a blank page each time DW adds
> another repetition. I then go in and delete it and alas my page works
> again.
> This must be a bug and I'm not sure why I am just now seeing my pages not
> display. For those looking at this, here is the code that I have to keep
> removing:

Somehow the code isn't identified as a Serverbehavior's participant and gets
added again and again when the serverbehavior is applied, did you change the
dreamweaver generated code in any way?
Installed any extensions that might have changed the edml files?
Created custom serverbehaviors that may interfere with the standard
dreamweaver ones?

Well after wasting a day I found that this block of code keeps getting added whenever I touch a recordset (open and close it for example). For whatever reason this is causing my page to display a blank page each time DW adds another repetition. I then go in and delete it and alas my page works again. This must be a bug and I'm not sure why I am just now seeing my pages not display. For those looking at this, here is the code that I have to keep removing:

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;
}