Problem with form validation

mosow · Jun 28, 2004

I have a form that I have created using FP 2000. I change the text
box to validate the entry. When bringing up the page in my browser
from our web server, I get the following message:

'DB1' is null or not an object

This is the name of the field I am trying to validate.

Any idea on why this is happening and how to correct?

TIA

Jim Buyens · Jun 28, 2004

Can you provide a URL?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

mosow · Jun 29, 2004

I can not give you a URL as this is part of an internal site. The
code is below, generated by FrontPage:

<html>

<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Release Date Comparison</title>
</head>

<body>

<a
href="rms_reports.htm">Return
to Report Menu</a>               
Date: <script language="VBScript">
document.write(FormatDateTime(Date(),0))</script>
           
Time: <script language="VBScript">
document.write(FormatDateTime(Time(),0))</script>

Release
Date Comparison

<script Language="JavaScript">
function FrontPage_Form1_Validator(theForm)
{

var checkOK = "0123456789-.,";
var checkStr = theForm.DB1.value;
var allValid = true;
var decPoints = 0;
var allNum = "";
for (i = 0; i < checkStr.length; i++)
{
ch = checkStr.charAt(i);
for (j = 0; j < checkOK.length; j++)
if (ch == checkOK.charAt(j))
break;
if (j == checkOK.length)
{
allValid = false;
break;
}
if (ch == ".")
{
allNum += ".";
decPoints++;
}
else if (ch != ",")
allNum += ch;
}
if (!allValid)
{
alert("Please enter only digit characters in the \"DB1\" field.");
theForm.DB1.focus();
return (false);
}

if (decPoints > 1)
{
alert("Please enter a valid number in the \"DB1\" field.");
theForm.DB1.focus();
return (false);
}
return (true);
}
//--></script>

<form BOTID="0" METHOD="POST" ACTION="DateComparison1.asp"
onsubmit="return FrontPage_Form1_Validator(this)"
name="FrontPage_Form1">
<table BORDER="0">
<tr>
<td>Prior Database:</td>
<td><input NAME="DB1"
VALUE="<%=Request("DB1")%>" size="20"></td>
</tr>
<tr>
<td>Prior Release:</td>
<td><input NAME="PV1" VALUE="<%=Request("PV1")%>"
size="20"></td>
</tr>
<tr>
<td>Current Database:</td>
<td><input NAME="DB2" VALUE="<%=Request("DB2")%>"
size="20"></td>
</tr>
<tr>
<td>Current Release:</td>
<td><input NAME="PV2" VALUE="<%=Request("PV2")%>"
size="20"></td>
</tr>
</table>
 
<input TYPE="Submit"><input TYPE="Reset">
</form>
<table width="815" border="1">
<thead>
<tr>
<td width="155">Object Family</td>
<td width="58" align="left">Object</td>
<td width="71" align="center">Prior 
Database</td>
<td width="62" align="center">Prior 
Version</td>
<td width="102" align="center">Prior Date 
Compiled</td>
<td width="71" align="center">Current 
Database</td>
<td width="62" align="center">Current 
Version</td>
<td width="102" align="center">Current  Date 
 Compiled</td>
<td width="104" align="center">Host 
System</td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Object Family Name,Object Name,Database Release
1,Product Version 1,Enterprise Date Compiled 1,Database Release
2,Product Version 2,Enterprise Date Compiled 2,HostSystem,HostSystem"
s-columntypes="200,200,2,200,200,2,200,200,200,200"
s-dataconnection="RMS97"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="Object
Family Name"
s-menuvalue="Object Family Name" b-tableborder="TRUE"
b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-ListFormat="0" b-makeform="TRUE"
s-recordsource="Date_Compare_Single"
s-displaycolumns="Object Family Name,Object Name,Database Release
1,Product Version 1,Enterprise Date Compiled 1,Database Release
2,Product Version 2,Enterprise Date Compiled 2,HostSystem"
s-criteria="{Database Release 1} EQ {DB1} + {Product Version 1} EQ
{PV1} + {Database Release 2} EQ {DB2} + {Product Version 2} EQ {PV2}
+"
s-order
s-sql="SELECT * FROM Date_Compare_Single WHERE (&quot;Database
Release 1&quot; = :

B1:: AND &quot;Product Version
1&quot; = :

V1:: AND &quot;Database Release 2&quot; =
:

B2:: AND &quot;Product Version 2&quot; = :

V2:

"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="DB1=0&amp;PV1=0&amp;DB2=0&amp;PV2=0"
s-NoRecordsFound="No records returned." i-MaxRecords="0"
i-GroupSize="0"
BOTID="0" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64
bgcolor="#FFFF00" align="left"
width="100%">Database Results regions will not preview
unless this page is fetched from a Web server with a web browser. The
following table row will repeat once for every record returned by the
query.</td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00"
align="left" width="100%">This is the start of a Database Results
region. The page must be fetched from a web server with a web browser
to display correctly; the current web is stored on your local disk or
network.</td></tr>"
b-WasTableFormat="TRUE" b-ReplaceDatabaseRegion="FALSE"
-->
<%
fp_sQry="SELECT * FROM Date_Compare_Single WHERE (""Database Release
1"" = :

B1:: AND ""Product Version 1"" = :

V1:: AND ""Database
Release 2"" = :

B2:: AND ""Product Version 2"" = :

V2:

"
fp_sDefault="DB1=0&PV1=0&DB2=0&PV2=0"
fp_sNoRecords="<tr><td colspan=9 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="RMS97"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Object Family Name"
fp_sMenuValue="Object Family Name"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>


<tr>
<td width="155"><%=FP_FieldVal(fp_rs,"Object Family Name")%>
</td>
<td width="58" align="left"><%=FP_FieldVal(fp_rs,"Object Name")%>
</td>
<td width="71" align="center"><%=FP_FieldVal(fp_rs,"Database Release 1")%>
</td>
<td width="62" align="center"><%=FP_FieldVal(fp_rs,"Product Version 1")%>
</td>
<td width="102" align="center"><%=FP_FieldVal(fp_rs,"Enterprise Date Compiled 1")%>
</td>
<td width="71" align="center"><%=FP_FieldVal(fp_rs,"Database Release 2")%>
</td>
<td width="62" align="center"><%=FP_FieldVal(fp_rs,"Product Version 2")%>
</td>
<td width="102" align="center"><%=FP_FieldVal(fp_rs,"Enterprise Date Compiled 2")%>
</td>
<td width="104" align="center"><%=FP_FieldVal(fp_rs,"HostSystem")%>
</td>
</tr>


</tbody>
</table>

</body>

</html>

Jim Buyens · Jun 29, 2004

I can't reproduce your entire setup because I don't have the
databases and other required files. However, when I copied
and pasted your code for the 'DB1' element, it worked fine.

Do you have script debugging turned on in IE? If not, turn it
on, then reproduce the error situation, then choose that Yes,
you want to enter the debugger. When prompted, choose Break,
and then the debugger will show you exactly which statement
is failing.

To turn on script debugging in IE, choose Tools, Internet Options,
Advanced. Then, under Browsing, clear Disable Script Debugging.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

mosow · Jun 30, 2004

I appreciate your looking at this for me. The line that I get the
error on is:

var checkStr = theForm.DB1.value;

I am not a javascript person. So I am relying on FrontPage to be
smart enough to generate all the code I need to make this work.

mosow · Jun 30, 2004

Thanks for looking at this. The line that it fails on is:

var checkStr = theForm.DB1.value;

Problem with form validation

mosow

Jim Buyens

mosow

Jim Buyens

mosow

mosow