Generate the wrong recordset in DA !

I use the wizard to make a backend ....
when I finished, it generate 6 pages for me ..
results,details,insert,delete,update,search....

but some error in recordsets which DA generate....

the update, details , delete pages has the error...

the delete page code generate by DA :

<?php
$ParamAgent_ID_WADAagent_profile = "-1";
if (isset($_GET['Agent_ID'])) {
$ParamAgent_ID_WADAagent_profile = (get_magic_quotes_gpc()) ? $_GET['Agent_ID'] : addslashes($_GET['Agent_ID']);
}
mysql_select_db($database_connection, $connection);
$query_WADAagent_profile = sprintf("SELECT Agent_ID, Agent_Name, Agent_Identity, Agent_Birth, Telephone_Home, Telephone_mobile, E_Mail, County_ID, Town_ID, Zip_ID, Road, Bank_ID, Bank_Account, Level_ID, User_Name, Pass_Word FROM agent_profile WHERE Agent_ID = %s", GetSQLValueString($ParamAgent_ID_WADAagent_profile, "int"));
$WADAagent_profile = mysql_query($query_WADAagent_profile, $connection) or die(mysql_error());
$row_WADAagent_profile = mysql_fetch_assoc($WADAagent_profile);
$totalRows_WADAagent_profile = mysql_num_rows($WADAagent_profile);?>

the detail page :
<?php
$ParamAgent_ID_WADAagent_profile = "-1";
if (isset($_GET['Agent_ID'])) {
$ParamAgent_ID_WADAagent_profile = (get_magic_quotes_gpc()) ? $_GET['Agent_ID'] : addslashes($_GET['Agent_ID']);
}
$ParamSessionAgent_ID_WADAagent_profile = "-1";
if (isset($_SESSION['WADA_Insert_agent_profile'])) {
$ParamSessionAgent_ID_WADAagent_profile = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_agent_profile'] : addslashes($_SESSION['WADA_Insert_agent_profile']);
}
$ParamAgent_ID2_WADAagent_profile = "-1";
if (isset($_GET['Agent_ID'])) {
$ParamAgent_ID2_WADAagent_profile = (get_magic_quotes_gpc()) ? $_GET['Agent_ID'] : addslashes($_GET['Agent_ID']);
}
mysql_select_db($database_connection, $connection);
$query_WADAagent_profile = sprintf("SELECT Agent_ID, Agent_Name, Agent_Identity, Agent_Birth, Telephone_Home, Telephone_mobile, E_Mail, County_ID, Town_ID, Zip_ID, Road, Bank_ID, Bank_Account, Level_ID, User_Name, Pass_Word FROM agent_profile WHERE Agent_ID = %s OR ( -1= %s AND Agent_ID= %s)", GetSQLValueString($ParamAgent_ID_WADAagent_profile, "int"),GetSQLValueString($ParamAgent_ID2_WADAagent_profile, "int"),GetSQLValueString($ParamSessionAgent_ID_WADAagent_profile, "int"));
$WADAagent_profile = mysql_query($query_WADAagent_profile, $connection) or die(mysql_error());
$row_WADAagent_profile = mysql_fetch_assoc($WADAagent_profile);
$totalRows_WADAagent_profile = mysql_num_rows($WADAagent_profile);?>

the update page :
<?php
$ParamAgent_ID_WADAagent_profile = "-1";
if (isset($_GET['Agent_ID'])) {
$ParamAgent_ID_WADAagent_profile = (get_magic_quotes_gpc()) ? $_GET['Agent_ID'] : addslashes($_GET['Agent_ID']);
}
mysql_select_db($database_connection, $connection);
$query_WADAagent_profile = sprintf("SELECT Agent_ID, Agent_Name, Agent_Identity, Agent_Birth, Telephone_Home, Telephone_mobile, E_Mail, County_ID, Town_ID, Zip_ID, Road, Bank_ID, Bank_Account, Level_ID, User_Name, Pass_Word FROM agent_profile WHERE Agent_ID = %s", GetSQLValueString($ParamAgent_ID_WADAagent_profile, "int"));
$WADAagent_profile = mysql_query($query_WADAagent_profile, $connection) or die(mysql_error());
$row_WADAagent_profile = mysql_fetch_assoc($WADAagent_profile);
$totalRows_WADAagent_profile = mysql_num_rows($WADAagent_profile);?>

when i double click the server behavior trying to make it correct
and click the test button..
the errors shows ....



can any body help me??

OS: win7 traditional chinese
DW cs4 english

This problem is caused by a the way Dreamweaver reads variables and using the Underscore Character in your column names.



When a variable is created in a recordset it is name "Param<ColumnName>". Dreamweaver writes the code for the parameter as "$Param<ColumnName>_<RecordsetName>.


upon re inspection, Dreamweaver sees everything after the first underscore character as the recordset name. so the column "Agent_ID" in the "WADAagent_profile" recordset will be named:
ParamAgent_ID

the code for the variable will be written as:
$ParamAgent_ID_WADAagent_profile


When you reinspect the recordset, Dreamweaver will read the parameter name as:
ParamAgent


and the recordset it is associated with as:
ID_WADAagent_profile

To keep the issue from occurring, you should avoid underscores in your column names.

To fix the problem, you will need to manually edit the code, and remove the underscores from the variabel names. change any instance of:
$ParamAgent_ID_WADAagent_profile

on the delete page to:
$ParamAgentID_WADAagent_profile


on the detail page, change these three:
$ParamAgent_ID_WADAagent_profile

$ParamSessionAgent_ID_WADAagent_profile

$ParamAgent_ID2_WADAagent_profile


to:
$ParamAgentID_WADAagent_profile

$ParamSessionAgentID_WADAagent_profile

$ParamAgentID2_WADAagent_profile



On the update page, change:
$ParamAgent_ID_WADAagent_profile

to:
$ParamAgentID_WADAagent_profile

after handcoding, it seems fine...
thanks for helping!

you're welcome.