Database wizard error - no default value

Shams Soomar · Sep 16, 2005

Hi..

I'm using Frontpage 2003 and Access 2003. I'm trying to create a form that
updates a table called tblusrinput. The Update_Form.asp page gives the the
user the ability to make updates to certain records. But once I press the
"update" button, while posts to update.asp, I get the following error from
the update.asp page:

Database Results Wizard Error
Description: Parameter ?_2 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I've reviewed the update query, but I'm not sure what's going on. Any help
would be greatly appreciated. Thanks!

Shams

Here's the code:

Update_Form.asp:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>BranchID</title>
</head>

<body>

<form BOTID="0" METHOD="POST" action="update_form.asp">
<input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
<table BORDER="0">
<tr>
<td><b>wkof</b></td>
<td>
<input TYPE="TEXT" NAME="wkof"
VALUE="<%=Server.HtmlEncode(Request("wkof"))%>"></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"></form>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select branchid, weekof, roster, trainwk1, trainwk2, newhires,
nxttrn, comments from tblusrinput where (weekof = '::wkof::')"
fp_sDefault="wkof=date()"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="branchid"
fp_sMenuValue="branchid"
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<form
METHOD="POST" action="update.asp">
<table BORDER="0">
<tr>
<td><b>branchid:</b></td>
<td>
<input NAME="branchid" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"branchid")%>"></td>
</tr>
<tr>
<td><b>weekof:</b></td>
<td>
<input NAME="weekof" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"weekof")%>"></td>
</tr>
<tr>
<td><b>roster:</b></td>
<td>
<input TYPE="TEXT" NAME="roster" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"roster")%>"></td>
</tr>
<tr>
<td><b>trainwk1:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk1" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk1")%>"></td>
</tr>
<tr>
<td><b>trainwk2:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk2" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk2")%>"></td>
</tr>
<tr>
<td><b>newhires:</b></td>
<td>
<input TYPE="TEXT" NAME="newhires" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"newhires")%>"></td>
</tr>
<tr>
<td><b>nxttrn:</b></td>
<td>
<input TYPE="TEXT" NAME="nxttrn" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"nxttrn")%>"></td>
</tr>
<tr>
<td><b>comments:</b></td>
<td>
<input TYPE="TEXT" NAME="comments" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"comments")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset"
NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="1"
clientside tag="BODY" preview="<table border=0 width="100%"><tr><td
bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results

region. said:
"><INPUT TYPE=Button VALUE=" >| "> [1/1]</NOBR><BR></td></tr></table>"

startspan -->
</body></html>

Update.asp

<table width="100%" border="1">
<thead>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="branchid,weekof,roster,trainwk1,trainwk2,newhires,nxttrn,comments"
s-columntypes="202,135,3,3,3,3,135,203" s-dataconnection="Database1"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0"
b-makeform="FALSE" s-recordsource s-displaycolumns s-criteria s-order
s-sql="update tblusrinput<br>set branchid='::branchid::', weekof='::wkof::',
roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
(branchid=::branchid:

and (weekof=::wkof:

" b-procedure="FALSE" clientside
suggestedext="asp"
s-defaultfields="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5"
botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font color="#000000">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.</font></td></tr>" startspan -->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="update tblusrinput set branchid='::branchid::', weekof='::wkof::',
roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
(branchid=::branchid:

and (weekof=::wkof:

"
fp_sDefault="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


</tbody>
</table>

p c · Sep 18, 2005

Don't have time to look at your code. But..

For your table, do you have any fields for which value is required and
for which your form did not pass values?

Or did you try to pass zero length string (e.g. "") to a table field
which does not allow zero length string.

...PC

Shams said:
Hi..

I'm using Frontpage 2003 and Access 2003. I'm trying to create a form that
updates a table called tblusrinput. The Update_Form.asp page gives the the
user the ability to make updates to certain records. But once I press the
"update" button, while posts to update.asp, I get the following error from
the update.asp page:

Database Results Wizard Error
Description: Parameter ?_2 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I've reviewed the update query, but I'm not sure what's going on. Any help
would be greatly appreciated. Thanks!

Shams

Here's the code:

Update_Form.asp:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>BranchID</title>
</head>

<body>

<form BOTID="0" METHOD="POST" action="update_form.asp">
<input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
<table BORDER="0">
<tr>
<td><b>wkof</b></td>
<td>
<input TYPE="TEXT" NAME="wkof"
VALUE="<%=Server.HtmlEncode(Request("wkof"))%>"></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"></form>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select branchid, weekof, roster, trainwk1, trainwk2, newhires,
nxttrn, comments from tblusrinput where (weekof = '::wkof::')"
fp_sDefault="wkof=date()"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="branchid"
fp_sMenuValue="branchid"
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<form
METHOD="POST" action="update.asp">
<table BORDER="0">
<tr>
<td><b>branchid:</b></td>
<td>
<input NAME="branchid" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"branchid")%>"></td>
</tr>
<tr>
<td><b>weekof:</b></td>
<td>
<input NAME="weekof" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"weekof")%>"></td>
</tr>
<tr>
<td><b>roster:</b></td>
<td>
<input TYPE="TEXT" NAME="roster" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"roster")%>"></td>
</tr>
<tr>
<td><b>trainwk1:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk1" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk1")%>"></td>
</tr>
<tr>
<td><b>trainwk2:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk2" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk2")%>"></td>
</tr>
<tr>
<td><b>newhires:</b></td>
<td>
<input TYPE="TEXT" NAME="newhires" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"newhires")%>"></td>
</tr>
<tr>
<td><b>nxttrn:</b></td>
<td>
<input TYPE="TEXT" NAME="nxttrn" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"nxttrn")%>"></td>
</tr>
<tr>
<td><b>comments:</b></td>
<td>
<input TYPE="TEXT" NAME="comments" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"comments")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset"
NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>

</body></html>

Update.asp

<table width="100%" border="1">
<thead>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="update tblusrinput set branchid='::branchid::', weekof='::wkof::',
roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
(branchid=::branchid: and (weekof=::wkof:"
fp_sDefault="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


</tbody>
</table>

Shams Soomar · Sep 19, 2005

PC thanks for your reply. I tried both your suggestions. I also made sure
that all the fields in the table in question allow zero length fields.
So...I'm lost. Any other thoughts? Here's the sample site if you want to
take a look at what I'm doing and where the error occurs.
www.shamsonline.com/staff If you click administration and pull the down
date, view, edit, and update, you'll see the error. Thanks for your help
again...I appreciate it.

p c said:
Don't have time to look at your code. But..

For your table, do you have any fields for which value is required and
for which your form did not pass values?

Or did you try to pass zero length string (e.g. "") to a table field
which does not allow zero length string.

...PC

Shams said:

Hi..

I'm using Frontpage 2003 and Access 2003. I'm trying to create a form that
updates a table called tblusrinput. The Update_Form.asp page gives the the
user the ability to make updates to certain records. But once I press the
"update" button, while posts to update.asp, I get the following error from
the update.asp page:

Database Results Wizard Error
Description: Parameter ?_2 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I've reviewed the update query, but I'm not sure what's going on. Any help
would be greatly appreciated. Thanks!

Shams

Here's the code:

Update_Form.asp:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>BranchID</title>
</head>

<body>

<form BOTID="0" METHOD="POST" action="update_form.asp">
<input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
<table BORDER="0">
<tr>
<td><b>wkof</b></td>
<td>
<input TYPE="TEXT" NAME="wkof"
VALUE="<%=Server.HtmlEncode(Request("wkof"))%>"></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"></form>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select branchid, weekof, roster, trainwk1, trainwk2, newhires,
nxttrn, comments from tblusrinput where (weekof = '::wkof::')"
fp_sDefault="wkof=date()"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="branchid"
fp_sMenuValue="branchid"
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<form
METHOD="POST" action="update.asp">
<table BORDER="0">
<tr>
<td><b>branchid:</b></td>
<td>
<input NAME="branchid" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"branchid")%>"></td>
</tr>
<tr>
<td><b>weekof:</b></td>
<td>
<input NAME="weekof" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"weekof")%>"></td>
</tr>
<tr>
<td><b>roster:</b></td>
<td>
<input TYPE="TEXT" NAME="roster" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"roster")%>"></td>
</tr>
<tr>
<td><b>trainwk1:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk1" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk1")%>"></td>
</tr>
<tr>
<td><b>trainwk2:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk2" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk2")%>"></td>
</tr>
<tr>
<td><b>newhires:</b></td>
<td>
<input TYPE="TEXT" NAME="newhires" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"newhires")%>"></td>
</tr>
<tr>
<td><b>nxttrn:</b></td>
<td>
<input TYPE="TEXT" NAME="nxttrn" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"nxttrn")%>"></td>
</tr>
<tr>
<td><b>comments:</b></td>
<td>
<input TYPE="TEXT" NAME="comments" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"comments")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset"
NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>

</body></html>

Update.asp

<table width="100%" border="1">
<thead>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="update tblusrinput set branchid='::branchid::', weekof='::wkof::',
roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
(branchid=::branchid: and (weekof=::wkof:"
fp_sDefault="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


</tbody>
</table>

Click to expand...

Shams Soomar · Sep 19, 2005

PC thanks for your reply. I tried both your suggestions. I also made sure
that all the fields in the table in question allow zero length fields.
So...I'm lost. Any other thoughts? Here's the sample site if you want to
take a look at what I'm doing and where the error occurs.
www.shamsonline.com/staff If you click administration and pull the down
date, view, edit, and update, you'll see the error. Thanks for your help
again...I appreciate it.

p c said:
Don't have time to look at your code. But..

For your table, do you have any fields for which value is required and
for which your form did not pass values?

Or did you try to pass zero length string (e.g. "") to a table field
which does not allow zero length string.

...PC

Shams said:

Hi..

I'm using Frontpage 2003 and Access 2003. I'm trying to create a form that
updates a table called tblusrinput. The Update_Form.asp page gives the the
user the ability to make updates to certain records. But once I press the
"update" button, while posts to update.asp, I get the following error from
the update.asp page:

Database Results Wizard Error
Description: Parameter ?_2 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I've reviewed the update query, but I'm not sure what's going on. Any help
would be greatly appreciated. Thanks!

Shams

Here's the code:

Update_Form.asp:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>BranchID</title>
</head>

<body>

<form BOTID="0" METHOD="POST" action="update_form.asp">
<input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
<table BORDER="0">
<tr>
<td><b>wkof</b></td>
<td>
<input TYPE="TEXT" NAME="wkof"
VALUE="<%=Server.HtmlEncode(Request("wkof"))%>"></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"></form>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select branchid, weekof, roster, trainwk1, trainwk2, newhires,
nxttrn, comments from tblusrinput where (weekof = '::wkof::')"
fp_sDefault="wkof=date()"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="branchid"
fp_sMenuValue="branchid"
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<form
METHOD="POST" action="update.asp">
<table BORDER="0">
<tr>
<td><b>branchid:</b></td>
<td>
<input NAME="branchid" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"branchid")%>"></td>
</tr>
<tr>
<td><b>weekof:</b></td>
<td>
<input NAME="weekof" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"weekof")%>"></td>
</tr>
<tr>
<td><b>roster:</b></td>
<td>
<input TYPE="TEXT" NAME="roster" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"roster")%>"></td>
</tr>
<tr>
<td><b>trainwk1:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk1" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk1")%>"></td>
</tr>
<tr>
<td><b>trainwk2:</b></td>
<td>
<input TYPE="TEXT" NAME="trainwk2" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"trainwk2")%>"></td>
</tr>
<tr>
<td><b>newhires:</b></td>
<td>
<input TYPE="TEXT" NAME="newhires" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"newhires")%>"></td>
</tr>
<tr>
<td><b>nxttrn:</b></td>
<td>
<input TYPE="TEXT" NAME="nxttrn" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"nxttrn")%>"></td>
</tr>
<tr>
<td><b>comments:</b></td>
<td>
<input TYPE="TEXT" NAME="comments" SIZE="40"
VALUE="<%=FP_FieldHTML(fp_rs,"comments")%>"></td>
</tr>
<tr>
<td COLSPAN="2"><br>
<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset"
NAME="fp_reset"></td>
</tr>
</table>
</form>
<hr>

</body></html>

Update.asp

<table width="100%" border="1">
<thead>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="update tblusrinput set branchid='::branchid::', weekof='::wkof::',
roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
(branchid=::branchid: and (weekof=::wkof:"
fp_sDefault="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


</tbody>
</table>

Click to expand...

Stefan B Rusynko · Sep 19, 2005

and (weekof=::wkof:

" b-procedure="FALSE" clientside
| > > suggestedext="asp"
| > >
s-defaultfields="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
| > > s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5"
| > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > > bgcolor="#FFFF00" width="100%"><font color="#000000">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.</font></td></tr>" startspan -->
| > > <% if 0 then %>
| > > <SCRIPT Language="JavaScript">
| > > document.write("<div style='background: yellow; color: black;'>The Database
| > > Results component on this page is unable to display database content. The
| > > page must have a filename ending in '.asp', and the web must be hosted on a
| > > server that supports Active Server Pages.</div>");
| > > </SCRIPT>
| > > <% end if %>
| > > <%
| > > fp_sQry="update tblusrinput set branchid='::branchid::', weekof='::wkof::',
| > > roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
| > > newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
| > > (branchid=::branchid:

and (weekof=::wkof:

Shams Soomar · Sep 19, 2005

Thanks for your reply Stefan. That's an interesting site. Very helpful with
a lot of material. I'll give that a shot.
Thanks again.

Shams

Stefan B Rusynko said:
Your problem is the search query is empty when the page is 1st loaded (until you hit submit)
To get around it see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

| PC thanks for your reply. I tried both your suggestions. I also made sure
| that all the fields in the table in question allow zero length fields.
| So...I'm lost. Any other thoughts? Here's the sample site if you want to
| take a look at what I'm doing and where the error occurs.
| www.shamsonline.com/staff If you click administration and pull the down
| date, view, edit, and update, you'll see the error. Thanks for your help
| again...I appreciate it.
|
| "p c" wrote:
|
| > Don't have time to look at your code. But..
| >
| > For your table, do you have any fields for which value is required and
| > for which your form did not pass values?
| >
| > Or did you try to pass zero length string (e.g. "") to a table field
| > which does not allow zero length string.
| >
| > ...PC
| >
| > Shams Soomar wrote:
| >
| > > Hi..
| > >
| > > I'm using Frontpage 2003 and Access 2003. I'm trying to create a form that
| > > updates a table called tblusrinput. The Update_Form.asp page gives the the
| > > user the ability to make updates to certain records. But once I press the
| > > "update" button, while posts to update.asp, I get the following error from
| > > the update.asp page:
| > >
| > > Database Results Wizard Error
| > > Description: Parameter ?_2 has no default value.
| > > Number: -2147217904 (0x80040E10)
| > > Source: Microsoft JET Database Engine
| > >
| > > I've reviewed the update query, but I'm not sure what's going on. Any help
| > > would be greatly appreciated. Thanks!
| > >
| > > Shams
| > >
| > > Here's the code:
| > >
| > > Update_Form.asp:
| > >
| > > <html>
| > >
| > > <head>
| > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
| > > Edit.
| > > FP_CharSet = "windows-1252"
| > > FP_CodePage = 1252 %>
| > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > > <title>BranchID</title>
| > > </head>
| > >
| > > <body>
| > >
| > > <form BOTID="0" METHOD="POST" action="update_form.asp">
| > > <input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
| > > <table BORDER="0">
| > > <tr>
| > > <td><b>wkof</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="wkof"
| > > VALUE="<%=Server.HtmlEncode(Request("wkof"))%>"></td>
| > > </tr>
| > > </table>
| > > <br>
| > > <input TYPE="Submit"><input TYPE="Reset"></form>
| > > 
| > > <% if 0 then %>
| > > <SCRIPT Language="JavaScript">
| > > document.write("<div style='background: yellow; color: black;'>The Database
| > > Results component on this page is unable to display database content. The
| > > page must have a filename ending in '.asp', and the web must be hosted on a
| > > server that supports Active Server Pages.</div>");
| > > </SCRIPT>
| > > <% end if %>
| > > <%
| > > fp_sQry="select branchid, weekof, roster, trainwk1, trainwk2, newhires,
| > > nxttrn, comments from tblusrinput where (weekof = '::wkof::')"
| > > fp_sDefault="wkof=date()"
| > > fp_sNoRecords="No records returned."
| > > fp_sDataConn="Database1"
| > > fp_iMaxRecords=0
| > > fp_iCommandType=1
| > > fp_iPageSize=1
| > > fp_fTableFormat=False
| > > fp_fMenuFormat=False
| > > fp_sMenuChoice="branchid"
| > > fp_sMenuValue="branchid"
| > > fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
| > > fp_iDisplayCols=8
| > > fp_fCustomQuery=True
| > > BOTID=0
| > > fp_iRegion=BOTID
| > > %>
| > > 
| > > <form
| > > METHOD="POST" action="update.asp">
| > > <table BORDER="0">
| > > <tr>
| > > <td><b>branchid:</b></td>
| > > <td>
| > > <input NAME="branchid" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"branchid")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>weekof:</b></td>
| > > <td>
| > > <input NAME="weekof" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"weekof")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>roster:</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="roster" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"roster")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>trainwk1:</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="trainwk1" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"trainwk1")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>trainwk2:</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="trainwk2" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"trainwk2")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>newhires:</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="newhires" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"newhires")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>nxttrn:</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="nxttrn" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"nxttrn")%>"></td>
| > > </tr>
| > > <tr>
| > > <td><b>comments:</b></td>
| > > <td>
| > > <input TYPE="TEXT" NAME="comments" SIZE="40"
| > > VALUE="<%=FP_FieldHTML(fp_rs,"comments")%>"></td>
| > > </tr>
| > > <tr>
| > > <td COLSPAN="2"><br>
| > > <input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset"
| > > NAME="fp_reset"></td>
| > > </tr>
| > > </table>
| > > </form>
| > > <hr>
| > > 
| > > </body></html>
| > >
| > > Update.asp
| > >
| > > <table width="100%" border="1">
| > > <thead>
| > > </thead>
| > > <tbody>
| > > 
| > > <% if 0 then %>
| > > <SCRIPT Language="JavaScript">
| > > document.write("<div style='background: yellow; color: black;'>The Database
| > > Results component on this page is unable to display database content. The
| > > page must have a filename ending in '.asp', and the web must be hosted on a
| > > server that supports Active Server Pages.</div>");
| > > </SCRIPT>
| > > <% end if %>
| > > <%
| > > fp_sQry="update tblusrinput set branchid='::branchid::', weekof='::wkof::',
| > > roster='::roster::', trainwk1='::trwk1::', trainwk2='::trwk2::',
| > > newhires='::newhires::', nxttrn='::nxttrndt::', comments='::comments::' where
| > > (branchid=::branchid: and (weekof=::wkof:"
| > >
fp_sDefault="branchid=Text&wkof=date()&roster=Integer&trwk1=Integer&trwk2=Integer&newhires=Integer&nxttrndt=date()&comments=Text&branchid=Text&wkof=date()"
| > > fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records
| > > returned.</td></tr>"
| > > fp_sDataConn="Database1"
| > > fp_iMaxRecords=256
| > > fp_iCommandType=1
| > > fp_iPageSize=5
| > > fp_fTableFormat=True
| > > fp_fMenuFormat=False
| > > fp_sMenuChoice=""
| > > fp_sMenuValue=""
| > > fp_sColTypes="&branchid=202&weekof=135&roster=3&trainwk1=3&trainwk2=3&newhires=3&nxttrn=135&comments=203&"
| > > fp_iDisplayCols=16
| > > fp_fCustomQuery=True
| > > BOTID=0
| > > fp_iRegion=BOTID
| > > %>
| > > 
| > > 
| > > </tbody>
| > > </table>
| > >
| > >
| > >
| > >
| > >
| > >
| > >
| > >
| >

Checkbox validation	4	May 19, 2008
Report Grouping	2	Feb 4, 2009
Can one include data from javascript in form	1	Dec 30, 2009
disable submit button HELP	1	Feb 14, 2006
UPDATE database problems	0	Aug 9, 2004
Database Results Wizard Error - FrontPage 2003	5	Mar 3, 2006
editing database with frontpage	1	Feb 23, 2008
editing database with results wizard	1	Feb 23, 2008

Database wizard error - no default value

Shams Soomar

p c

Shams Soomar

Shams Soomar

Stefan B Rusynko

Shams Soomar

Ask a Question

Similar Threads