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