close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

recordsets adding duplicate code

Thread began 5/06/2010 10:45 pm by Russell Collins | Last modified 5/10/2010 1:04 pm by Jimmy Wu | 882 views | 4 replies |

Russell CollinsBeta Tester

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

Russell CollinsBeta Tester

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

Sign in to reply to this post

Russell CollinsBeta Tester

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

Sign in to reply to this post

Jimmy Wu

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...