Jump to content

Recommended Posts

I am trying to create a simple record insertion form in Dreamweaver MX. I create a simple recordset, then I create a form. Then I select Insert Record from the menu. I've done is on several pages with no problem at all. But I've got one table that Dreamweaver just won't allow me to add records to.

 

In the Server Behavior box, next to the Record Insertion behavior, is a red exclamation point. When I open it, I get a dialogue box that says "Could not find the selected tag node."

 

I've been all over the Internet trying to figure out what this means and how to fix it. I've found a few postings similar to the one I'm making now, but nobody ever gets an answer (including on the Macromedia forums). Is this a Dreamweaver bug? Or am I just missing something?

 

Here's the code:

 

<?php require_once('../../Connections/CDBlog.php');

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

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
 $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
 $insertSQL = sprintf("INSERT INTO tblspecs VALUES (NULL, %s, %s, %s, %s, %s, %s, %s)",
                      GetSQLValueString($HTTP_POST_VARS['projectid'], "int"),
                      GetSQLValueString($HTTP_POST_VARS['medium'], "text"),
                      GetSQLValueString($HTTP_POST_VARS['length'], "text"),
                      GetSQLValueString($HTTP_POST_VARS['color'], "text"),
                      GetSQLValueString($HTTP_POST_VARS['completion'], "date"),
                      GetSQLValueString($HTTP_POST_VARS['daterange'], "text"),
                      GetSQLValueString($HTTP_POST_VARS['venue'], "text"));

 mysql_select_db($database_CDBlog, $CDBlog);
 $Result1 = mysql_query($insertSQL, $CDBlog) or die(mysql_error());

 $insertGoTo = "projects.php";
 if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
   $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
   $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
 }
 header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_CDBlog, $CDBlog);
$query_rsSpecs = "SELECT * FROM tblspecs";
$rsSpecs = mysql_query($query_rsSpecs, $CDBlog) or die(mysql_error());
$row_rsSpecs = mysql_fetch_assoc($rsSpecs);
$totalRows_rsSpecs = mysql_num_rows($rsSpecs);
?>
<form name="form1" method="post" action="">
<p>Project: 
 <input name="projectid" type="text" id="projectid">
</p>
<p>Medium: 
 <input name="medium" type="text" id="medium">
</p>
<p>Length: 
 <input name="length" type="text" id="length">
</p>
<p>Color: 
 <input name="color" type="text" id="color">
</p>
<p>Completion Date: 
 <input name="completion" type="text" id="competion">
</p>
<p>Date Range: 
 <input name="daterange" type="text" id="daterange">
</p>
<p>Venue: 
 <input name="venue" type="text" id="venue">
</p>
<p>
 <input type="submit" name="Submit" value="Submit">
</p>
</form>
<?php
mysql_free_result($rsSpecs);
?>

Link to comment
https://forums.phpfreaks.com/topic/2816-could-not-find-the-selected-tag-node/
Share on other sites

  • 1 month later...

I just ran into the same thing today. I found that dreamweaver didn't like "length" as a form field. I noticed you had "length" as a from field also. I renamed that text field and everything worked fine. Probably too late to help you out but maybe this will help the next forum reader save some time.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.