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.

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.

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?

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.

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?

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

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

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

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?

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.