Participant

Question

Dreamweaver cs5 recordsets issues...frustating! any ideas?

Forum|Forum|15 years ago
September 6, 2010
4 replies
3074 views

Hi- any suggestion on how to deal with D cs5 software recordsets issues. Most of the time when I open a page that has a recordsets, or when I tried to edit or when creating recordsets or deleting, using the recordsets window, the program keeps crashing!! it is very frustrating, and I am not adding additional custom code to the recorsets, the software keeps crashing with its own generated code. If I switch between simple and advanced mode, it does the same thing.

Sometimes, when you try to edit a recordset it duplicates the recordset instead of editing the existing one.

I have been waiting for an update for this issue but nothing....I am using Windows 7 and developing in PHP/MySQL

Thanks,

Renier

Server side applications

This topic has been closed for replies.

N

nickwhyles

Participating Frequently

..It also adds another (reduntant) connection line at the top too:

<?php require_once('../Connections/latitude.php'); ?>

I end up with several that I delete, leaving just one...

K

KellyKH

Participating Frequently

I've just done a bit of testing and might have something.

I made a simple PHP page with any SELECT statement using the advanced recordset panel.

I could edit this to my hearts content and all is good ..... until.......I upload it to the server.

Then, when I change my recordset in the panel (or even just open it and close it) the recordset is duplicated. If I then use UNDO , then we're back to normal, can edit happily.

In fact whenever I interact with the server, like looking at MANAGE SITES for instance, and I then open and close the recordset, the recordset is duplicated.

So it seems it's something to do with connecting to the server. I tried altering a few settings but couldn't shake the problem. If anyone can use this to solve our problem then I'd be very happy to hear about it.

AS A GETAROUND. AFTER you upload your page, either close and re-open it before you edit your recordset. OR open the recordset, close it (problem occurs) then UNDO and go again.

Try it out, see if you get the same.

Kelly.

Lon_Winters

Inspiring

Kelly, I think you're on the right track - There have been numerous complaints over the years about the "interacting with server" thing popping up for no good apparent reason. That part of it alone I think is worse when working in ASP - it feels the need to interact with the server when I go to select something as innocuous as static text on the page!

My next stretch of work will be back to PHP sites, so I'll keep a close watch on things and report back if I learn or see anything suspicious.

N

nickwhyles

Participating Frequently

I've got used to it now.. It's very consistent when it does it so I just check which is the latest SQL query I wanted and just delete the old one that remains. If you look you'll notice that the old code starts in the middle of a line, which makes it a bit more difficult to see:

$row_rsDomjobs = mysql_fetch_assoc($rsDomjobs);(OLD STARTS HERE)if (isset($_GET['totalRows_rsDomjobs'])) {

If you split them apart at teh point shown above you'll see the 2 blocks of code are similar, apart obviously form your new SQL query. Just delete the old one..

I can't believe it hasn't been fixed on CS5 as it did it in 3 and 4 too. I presume most people who produce more dynamic sites use CF or just code it themselves, as I now do.. It's disappointing that Adobe don't even acknowledge the problem though

T

Tradewinds_Australasia

Participant

I am having the same problems but instead of editing what I do is save my work, delete the record set and create a new one. I bit of a nuicence but for me it is better than working out what code has been duplicated and/or deleted and having to correct it.

Lawrence_Cramer

Inspiring

Has it done this since you first installed CS5, or did it develop this behavior later on? Have you tried installing the Dreamweaver CS5 updater? It focuses mostly on HTML5 updates, but there were a number of bug fixes, perhaps this will help. After trying this if it still crashes you may have to try a full uninstall and reinstall... Or contact Adobe Support directly.

--
Lawrence Carmer - *Adobe Community Professional*
http://www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in PHP and ColdFusion

Stay updated - http://blog.cartweaver.com

Lon_Winters

Inspiring

Here are the steps I would take when I start seeing crashes when using recordsets or other server behaviors. But I'm still on cs4, so it may be purely a CS5 issue as mentioned above.

1. Delete the Wincache file (usually only a temporary fix)

2. Could be a conflict with an installed 3rd party extension.

3. Does it happen on just a particular page, or any page? Iff it's just one, you can try on a blank or less populated page - I've occasionally had to just re-build the page and that would help. Sometimes it was just the removal of a single field of dynamic data tied to the recordset. removing this binding and re-adding ti worked, even though the code was exactly the same in both cases.

4. Deleting the database connection and removing the connection scripts, then re-creating the connection

And sometimes, for whatever reason, I have seen where it added another set of recordset code, or just parts of it. And sometimes when you delete a recordset, parts still remain. It is frustrating, no doubt.

K

KellyKH

Participating Frequently

I'm having the same probs with the recordsets duplicating. It's driving me mad and I have a lot of stuff to get on with. The program is almost unusable because of this. I will try some of these suggestions but does anyone have a definate answer why this is happening yet?

I've made a fresh page, fresh connection, simple MYSQL statement, put a couple of results onto the page as a test, ok.

Went back into the recordset from the panel, edited the recordset and it duplicated it!! So nothing to do with Variables or repeat regions.

Any ideas please. Here is my code.

<?php require_once('MyConnections/connection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
}
return $theValue;
}
}

mysql_select_db($database_database, $Database);
$query_Recordset1 = "SELECT * FROM cards ";
$Recordset1 = mysql_query($query_Recordset1, $Database) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);mysql_select_db($database_database, $Database);
$query_Recordset1 = "SELECT * FROM cards where EmployeeID = 1";
$Recordset1 = mysql_query($query_Recordset1, $Database) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded