Why won't this validate? It keeps returning
I started with the DataAssist wizard, which made me a users_insert and a users_detail.
I seem to have set up the server validations correctly. No matter what I put in, I keep getting the page returned for correction. I have attached a screen shot of the form.
Thanks.
Larry
-----------------------------
<?php require_once("Connections/Premiere.php"); ?>
<?php require_once("WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php require_once("WA_ValidationToolkit/WAVT_Scripts_PHP.php"); ?>
<?php require_once("WA_ValidationToolkit/WAVT_ValidatedForm_PHP.php"); ?>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$WAFV_Redirect = "users_Detail.php";
$_SESSION['WAVT_usersInsert_Errors'] = "";
if ($WAFV_Redirect == "") {
$WAFV_Redirect = $_SERVER["PHP_SELF"];
}
$WAFV_Errors = "";
$WAFV_Errors .= WAValidateRQ(((isset($_POST["UserFirstName"]))?$_POST["UserFirstName"]:"") . "",false,1);
$WAFV_Errors .= WAValidateRQ(((isset($_POST["UserLastName"]))?$_POST["UserLastName"]:"") . "",false,2);
$WAFV_Errors .= WAValidateEM(((isset($_POST["UserEmail"]))?$_POST["UserEmail"]:"") . "",true,3);
$WAFV_Errors .= WAValidatePN(((isset($_POST["UserPhone"]))?$_POST["UserPhone"]:"") . "",true,false,false,4);
$WAFV_Errors .= WAValidatePN(((isset($_POST["UserPhoneM"]))?$_POST["UserPhoneM"]:"") . "",true,false,false,5);
$WAFV_Errors .= WAValidateAN(((isset($_POST["JobType"]))?$_POST["JobType"]:"") . "",true,true,true,true,"",true,6);
if ($WAFV_Errors != "") {
PostResult($WAFV_Redirect,$WAFV_Errors,"usersInsert");
}
}
?>
<?php
// WA Application Builder Insert
if (isset($_POST["Insert_x"])) // Trigger
{
$WA_connection = $Premiere;
$WA_table = "users";
$WA_sessionName = "WADA_Insert_users";
$WA_redirectURL = "/users_Detail.php";
$WA_keepQueryString = false;
$WA_indexField = "UserID";
$WA_fieldNamesStr = "UserEmail|UserPassword|UserFirstName|UserLastName|UserCity|UserState|UserZip|UserEmailVerified|UserRegistrationDate|UserVerificationCode|UserIP|UserPhone|UserPhoneM|TimeToCall|UserFax|UserCountry|JobType|JobNotes|UserAddress|UserAddress2";
$WA_fieldValuesStr = "".((isset($_POST["UserEmail"]))?$_POST["UserEmail"]:"") ."" . "|" . "".((isset($_POST["UserPassword"]))?$_POST["UserPassword"]:"") ."" . "|" . "".((isset($_POST["UserFirstName"]))?$_POST["UserFirstName"]:"") ."" . "|" . "".((isset($_POST["UserLastName"]))?$_POST["UserLastName"]:"") ."" . "|" . "".((isset($_POST["UserCity"]))?$_POST["UserCity"]:"") ."" . "|" . "".((isset($_POST["UserState"]))?$_POST["UserState"]:"") ."" . "|" . "".((isset($_POST["UserZip"]))?$_POST["UserZip"]:"") ."" . "|" . "".((isset($_POST["UserEmailVerified"]))?$_POST["UserEmailVerified"]:"") ."" . "|" . "".((isset($_POST["UserRegistrationDate"]))?$_POST["UserRegistrationDate"]:"") ."" . "|" . "".((isset($_POST["UserVerificationCode"]))?$_POST["UserVerificationCode"]:"") ."" . "|" . "".((isset($_POST["UserIP"]))?$_POST["UserIP"]:"") ."" . "|" . "".((isset($_POST["UserPhone"]))?$_POST["UserPhone"]:"") ."" . "|" . "".((isset($_POST["UserPhoneM"]))?$_POST["UserPhoneM"]:"") ."" . "|" . "".((isset($_POST["TimeToCall"]))?$_POST["TimeToCall"]:"") ."" . "|" . "".((isset($_POST["UserFax"]))?$_POST["UserFax"]:"") ."" . "|" . "".((isset($_POST["UserCountry"]))?$_POST["UserCountry"]:"") ."" . "|" . "".((isset($_POST["JobType"]))?$_POST["JobType"]:"") ."" . "|" . "".((isset($_POST["JobNotes"]))?$_POST["JobNotes"]:"") ."" . "|" . "".((isset($_POST["UserAddress"]))?$_POST["UserAddress"]:"") ."" . "|" . "".((isset($_POST["UserAddress2"]))?$_POST["UserAddress2"]:"") ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,NULL|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,''|',none,''|none,none,NULL|',none,''|',none,''|',none,''";
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_Premiere;
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
$insertParamsObj = WA_AB_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";
$MM_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$_SESSION[$WA_sessionName] = mysql_insert_id();
if ($WA_redirectURL != "") {
if ($WA_keepQueryString && $WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos($WA_redirectURL, '?') === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
header("Location: ".$WA_redirectURL);
}
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Insert users</title>
<link href="/WA_DataAssist/styles/Arial.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
@import url("WA_DataAssist/styles/Refined_Pacifica.css");
-->
</style>
</head>
<body>
<div class="WADAInsertContainer">
<form action="users_Detail.php" method="post" name="WADAInsertForm" id="WADAInsertForm">
<div class="WADAHeader">Insert Record</div>
<div class="WADAHorizLine"><img src="/WA_DataAssist/images/_tx_.gif" alt="" height="1" width="1" border="0" /></div>
<table width="686" border="0" cellpadding="0" cellspacing="0" class="WADADataTable">
<tr>
<th class="WADADataTableHeader"> </th>
<td colspan="2" align="center"class="WADANoResultsMessage"><?php
if (ValidatedField('usersDetail','usersDetail')) {
if ((strpos((",".ValidatedField("usersDetail","usersDetail").","), "," . "" . ",") !== false || "" == "")) {
if (!(false)) {
?>
Please review and fill in the items noted below
<?php //WAFV_Conditional users_Detail.php usersDetail( 3: )
}
}
}?></td>
</tr>
<tr>
<th width="202" class="WADADataTableHeader">First Name:</th>
<td width="276" class="WADADataTableCell"><input name="UserFirstName" type="text" id="UserFirstName" value="<?php echo(ValidatedField("usersDetail","UserFirstName")) ?>" size="32" /></td>
<td width="649"> <span class="WADANoResultsMessage">
<?php
if (ValidatedField('usersDetail','usersDetail')) {
if ((strpos((",".ValidatedField("usersDetail","usersDetail").","), "," . "2" . ",") !== false || "2" == "")) {
if (!(false)) {
?>
We need your first name
<?php //WAFV_Conditional users_Detail.php usersDetail(2: )
}
}
}?></span></td>
</tr>
<tr>
<th class="WADADataTableHeader">Last Name:</th>
<td class="WADADataTableCell"><input type="text" name="UserLastName" id="UserLastName" value="<?php echo(ValidatedField("usersDetail","UserLastName")) ?>" size="32" /></td>
<td class="WADANoResultsMessage"><?php
if (ValidatedField('usersDetail','usersDetail')) {
if ((strpos((",".ValidatedField("usersDetail","usersDetail").","), "," . "3" . ",") !== false || "3" == "")) {
if (!(false)) {
?>
We need your last name
<?php //WAFV_Conditional users_Detail.php usersDetail(3: )
}
}
}?></td>
</tr>
One problem I can see is that the form action is set to go to the users_Detail.php page. the action should be left blank so that the form will post to itself. you will need to redo the validation show if behaviors, and choose the users_insert page as the validation page. 
