close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dreamweaver hangs on Insert/Modify $InsertGoTo or $UpdateGoTo

Thread began 12/04/2015 9:36 am by Ron | Last modified 1/21/2016 8:32 pm by Ray Borduin | 851 views | 9 replies |

Ron

Dreamweaver hangs on Insert/Modify $InsertGoTo or $UpdateGoTo

Hello,

My GoTo redirects cause dreamweaver to hang on these:

INSERT: "portalindex.php?loc=results&id=testresults&recordID=" . mysql_insert_id();
UPDATE: "portalindex.php?loc=results&id=testresults&recordID=" . $_GET['recordID'];

Is there a problem with the quotes? I tried single quotes and the results were the same. They worked in the old server behaviors.

Sign in to reply to this post

Ray BorduinWebAssist

Can I get a url to reproduce the problem and FTP access to debug? I'm not sure what would cause this, but I'll debug it and report back to you.

Sign in to reply to this post

Ron

Everything is on my local machine. No URL or FTP access. As a 12 year Senior Web Software Tester (back in the day) I wrote the crappiest bug. SOrry.

The issue happens when selecting the files in DW (via the file tree or splash screen) that contain the URL redirects for INSERT or UPDATE. I believe it has something to do with DW loading the dynamically linked files information. Can the functionality of loading the dynamic data be turned off so that I can debug the code? Thoughts?

Sign in to reply to this post

Ray BorduinWebAssist

Try adding this to the end of the line:
[code]
INSERT: "portalindex.php?loc=results&id=testresults&recordID=" . mysql_insert_id() ."";
UPDATE: "portalindex.php?loc=results&id=testresults&recordID=" . $_GET['recordID'] ."";
[code]

Dreamweaver expects those lines to end with a double quote, and when they don't it can cause DW to get confused and hang for a long time.

Sign in to reply to this post

Ron

mysql_insert_id() is causing an error:

Warning: mysql_insert_id() [function.mysql-insert-id]: Access denied for user ''@'localhost' (using password: NO) in C:\inetpub\wwwroot....
Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in C:\inetpub\wwwroot\.......

Should I be moving to mysqli? Does webassist support this? How do I do this without openning a new connection?

Sign in to reply to this post

Ray BorduinWebAssist

Can I see the page and line reference for the line of code with the error? I can probably suggest a solution.

Sign in to reply to this post

Ron

<?php
if (isset($_POST["AddTaskButton"]) || isset($_POST["AddTaskButton_x"])) {
$InsertQuery = new WA_MySQLi_Query($Old4thDB_i);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "tasks";
$InsertQuery->bindColumn("tasksName", "s", "".((isset($_POST["addTaskName"]))?$_POST["addTaskName"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("tasksDescription", "s", "".((isset($_POST["addTaskInformation"]))?$_POST["addTaskInformation"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$NewRecordID = ""; //Possible add variable for mysqli

// ERROR LINE

$InsertGoTo = "portalindex.php?loc=tasks&id=tasks_details&recordID=" . mysql_insert_id() . "";

//
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>

Sign in to reply to this post

Ray BorduinWebAssist

That is a mysql function and you are doing a mysqli insert... try using: $InsertQuery->InsertID

Sign in to reply to this post

Ron

is there documentation explaining the functionality in the queryobj.php file? As the objects uses this file can I just add the MySqli funtions to it when needed so I do not have to open a new connection every time I want to access a MySqli function?

Sign in to reply to this post

Ray BorduinWebAssist

There is no direct documentation of the code itself, only the UI's that use it. You could add to the file, but when we come out with new versions we would be overwriting it, so it is something to be weary of... you may want to extend the class in a separate php file you can include after it with your own additions.

Sign in to reply to this post
loading

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...