any ideas why I can update one table in my database but not the other?

RasberryStolli · Sep 22, 2006

THIS DATABASE RESULTS GENERATES THE FOLLOWING ERROR WHEN TRYING TO
UPDATE A TABLE

Database Results Wizard Error Your page contains a query with user
input parameters that could
not be resolved. This could happen if your DatabaseRegionStart webbot
has an empty or
missing s-columnnames or s-columntypes attributes. You may need to read
Microsoft Knowledge
Base Article 817029. One or more form fields were empty. You should
provide default values for all form fields that are used
in the query.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>Vendor search results</title>
<meta name="Microsoft Theme" content="aftrnoon 1011, default">
</head>

<body>

<form method="POST" name="vresults.asp" action="vresults.asp"
target="_parent">
Vendor search
results

<% 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 * FROM VENDORS WHERE (vname LIKE '%::vname::%')"
fp_sDefault="vname="
fp_sNoRecords="NO VENDOR INFORMATION FOUND!!!!!!!!!!"
fp_sDataConn="vendorsandcontracts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="VID"
fp_sMenuValue="VID"
fp_sColTypes="&VID=3&vname=202&vfirstname=202&vlastname=202&vstreetaddress=202&vcity=202&vstate=202&vzip=202&vphone=202&vext=202&vfax=202&vemail=202&vcomments=202&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<ul>
<li>VID: <%=FP_FieldVal(fp_rs,"VID")%></li>
<li>vname: <a
href="vupdate.asp?vname=<%=FP_FieldURL(fp_rs,"vname")%>"><%=FP_FieldVal(fp_rs,"vname")%></a>Click
here to update Vendor data</li>
<li>vfirstname: <%=FP_FieldVal(fp_rs,"vfirstname")%></li>
<li>vlastname: <%=FP_FieldVal(fp_rs,"vlastname")%></li>
<li>vstreetaddress: <%=FP_FieldVal(fp_rs,"vstreetaddress")%></li>
<li>vcity: <%=FP_FieldVal(fp_rs,"vcity")%></li>
<li>vstate: <%=FP_FieldVal(fp_rs,"vstate")%></li>
<li>vzip: <%=FP_FieldVal(fp_rs,"vzip")%></li>
<li>vphone: <%=FP_FieldVal(fp_rs,"vphone")%></li>
<li>vext: <%=FP_FieldVal(fp_rs,"vext")%></li>
<li>vfax: <%=FP_FieldVal(fp_rs,"vfax")%></li>
<li>vemail: <%=FP_FieldVal(fp_rs,"vemail")%></li>
<li>vcomments: <%=FP_FieldVal(fp_rs,"vcomments")%></li>
</ul>
<hr>

<hr>
 

<a href="vindex.htm">Return to
Index</a>
<a href="vsearch.asp">Return to Search
page</a>
 
 
</form>

</body>

</html>

THIS ONE WORKS FINE
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>Update Contract Records</title>
<meta name="Microsoft Theme" content="aftrnoon 1011, default">
</head>

<body>

Update Contract
Records
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Comments,StartRenewalProcessingDate,ExpirationDate,ContractName,ID"
s-columntypes="203,135,135,202,3"
s-dataconnection="vendorsandcontracts" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="2" b-makeform="FALSE"
s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE
ContractTable SET ExpirationDate ='::ExpirationDate::' ,
StartRenewalProcessingDate =' ::StartRenewalProcessingDate::' ,
Comments = '::Comments::' WHERE (ID = ::ID:

" b-procedure="FALSE"
clientside suggestedext="asp"
s-defaultfields="ExpirationDate=&amp;StartRenewalProcessingDate=&amp;Comments=&amp;ID="
s-norecordsfound="Your update request has been processed."
i-maxrecords="256" i-groupsize="0" botid="0"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0
width="100%"><tr><td
bgcolor="#FFFF00">This is the start of a Database Results
region.</td></tr></table>" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE"
-->
<% 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 ContractTable SET ExpirationDate ='::ExpirationDate::'
, StartRenewalProcessingDate =' ::StartRenewalProcessingDate::' ,
Comments = '::Comments::' WHERE (ID = ::ID:

"
fp_sDefault="ExpirationDate=&StartRenewalProcessingDate=&Comments=&ID="
fp_sNoRecords="Your update request has been processed."
fp_sDataConn="vendorsandcontracts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Comments=203&StartRenewalProcessingDate=135&ExpirationDate=135&ContractName=202&ID=3&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<hr>


<a href="vindex.htm">return to Index page</a>

</body>

</html>
Both are from the same database in fpdb just different tables.
I have tried everything. Any suggestions would be appreciated.

Andrew Murray · Sep 23, 2006

Try redoing the form that writes to the table (re-do the connection to the
db & table) etc, and republish the page.

The clue to the problem is in the error below about a missing colum or
field, or empty field.

Have you read MSKB #817029?

RasberryStolli said:
THIS DATABASE RESULTS GENERATES THE FOLLOWING ERROR WHEN TRYING TO
UPDATE A TABLE

Database Results Wizard Error Your page contains a query with user
input parameters that could
not be resolved. This could happen if your DatabaseRegionStart webbot
has an empty or
missing s-columnnames or s-columntypes attributes. You may need to read
Microsoft Knowledge
Base Article 817029. One or more form fields were empty. You should
provide default values for all form fields that are used
in the query.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>Vendor search results</title>
<meta name="Microsoft Theme" content="aftrnoon 1011, default">
</head>

<body>

<form method="POST" name="vresults.asp" action="vresults.asp"
target="_parent">
Vendor search
results

<% 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 * FROM VENDORS WHERE (vname LIKE '%::vname::%')"
fp_sDefault="vname="
fp_sNoRecords="NO VENDOR INFORMATION FOUND!!!!!!!!!!"
fp_sDataConn="vendorsandcontracts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="VID"
fp_sMenuValue="VID"
fp_sColTypes="&VID=3&vname=202&vfirstname=202&vlastname=202&vstreetaddress=202&vcity=202&vstate=202&vzip=202&vphone=202&vext=202&vfax=202&vemail=202&vcomments=202&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<ul>
<li>VID: <%=FP_FieldVal(fp_rs,"VID")%></li>
<li>vname: <a
href="vupdate.asp?vname=<%=FP_FieldURL(fp_rs,"vname")%>"><%=FP_FieldVal(fp_rs,"vname")%></a>Click
here to update Vendor data</li>
<li>vfirstname: <%=FP_FieldVal(fp_rs,"vfirstname")%></li>
<li>vlastname: <%=FP_FieldVal(fp_rs,"vlastname")%></li>
<li>vstreetaddress: <%=FP_FieldVal(fp_rs,"vstreetaddress")%></li>
<li>vcity: <%=FP_FieldVal(fp_rs,"vcity")%></li>
<li>vstate: <%=FP_FieldVal(fp_rs,"vstate")%></li>
<li>vzip: <%=FP_FieldVal(fp_rs,"vzip")%></li>
<li>vphone: <%=FP_FieldVal(fp_rs,"vphone")%></li>
<li>vext: <%=FP_FieldVal(fp_rs,"vext")%></li>
<li>vfax: <%=FP_FieldVal(fp_rs,"vfax")%></li>
<li>vemail: <%=FP_FieldVal(fp_rs,"vemail")%></li>
<li>vcomments: <%=FP_FieldVal(fp_rs,"vcomments")%></li>
</ul>
<hr>

<hr>
 

<a href="vindex.htm">Return to
Index</a>
<a href="vsearch.asp">Return to Search
page</a>
 
 
</form>

</body>

</html>

THIS ONE WORKS FINE
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>Update Contract Records</title>
<meta name="Microsoft Theme" content="aftrnoon 1011, default">
</head>

<body>

Update Contract
Records

<% 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 ContractTable SET ExpirationDate ='::ExpirationDate::'
, StartRenewalProcessingDate =' ::StartRenewalProcessingDate::' ,
Comments = '::Comments::' WHERE (ID = ::ID:"
fp_sDefault="ExpirationDate=&StartRenewalProcessingDate=&Comments=&ID="
fp_sNoRecords="Your update request has been processed."
fp_sDataConn="vendorsandcontracts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Comments=203&StartRenewalProcessingDate=135&ExpirationDate=135&ContractName=202&ID=3&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<hr>


<a href="vindex.htm">return to Index page</a>

</body>

</html>
Both are from the same database in fpdb just different tables.
I have tried everything. Any suggestions would be appreciated.

RasberryStolli · Sep 25, 2006

I tried all of that before but I sure appreciate the response. What
did finally work after days of frustration was to put my update fields
in brackets in my update query. It works!

Andrew said:
Try redoing the form that writes to the table (re-do the connection to the
db & table) etc, and republish the page.

The clue to the problem is in the error below about a missing colum or
field, or empty field.

Have you read MSKB #817029?

RasberryStolli said:

THIS DATABASE RESULTS GENERATES THE FOLLOWING ERROR WHEN TRYING TO
UPDATE A TABLE

Database Results Wizard Error Your page contains a query with user
input parameters that could
not be resolved. This could happen if your DatabaseRegionStart webbot
has an empty or
missing s-columnnames or s-columntypes attributes. You may need to read
Microsoft Knowledge
Base Article 817029. One or more form fields were empty. You should
provide default values for all form fields that are used
in the query.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>Vendor search results</title>
<meta name="Microsoft Theme" content="aftrnoon 1011, default">
</head>

<body>

<form method="POST" name="vresults.asp" action="vresults.asp"
target="_parent">
Vendor search
results

<% 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 * FROM VENDORS WHERE (vname LIKE '%::vname::%')"
fp_sDefault="vname="
fp_sNoRecords="NO VENDOR INFORMATION FOUND!!!!!!!!!!"
fp_sDataConn="vendorsandcontracts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="VID"
fp_sMenuValue="VID"
fp_sColTypes="&VID=3&vname=202&vfirstname=202&vlastname=202&vstreetaddress=202&vcity=202&vstate=202&vzip=202&vphone=202&vext=202&vfax=202&vemail=202&vcomments=202&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<ul>
<li>VID: <%=FP_FieldVal(fp_rs,"VID")%></li>
<li>vname: <a
href="vupdate.asp?vname=<%=FP_FieldURL(fp_rs,"vname")%>"><%=FP_FieldVal(fp_rs,"vname")%></a>Click
here to update Vendor data</li>
<li>vfirstname: <%=FP_FieldVal(fp_rs,"vfirstname")%></li>
<li>vlastname: <%=FP_FieldVal(fp_rs,"vlastname")%></li>
<li>vstreetaddress: <%=FP_FieldVal(fp_rs,"vstreetaddress")%></li>
<li>vcity: <%=FP_FieldVal(fp_rs,"vcity")%></li>
<li>vstate: <%=FP_FieldVal(fp_rs,"vstate")%></li>
<li>vzip: <%=FP_FieldVal(fp_rs,"vzip")%></li>
<li>vphone: <%=FP_FieldVal(fp_rs,"vphone")%></li>
<li>vext: <%=FP_FieldVal(fp_rs,"vext")%></li>
<li>vfax: <%=FP_FieldVal(fp_rs,"vfax")%></li>
<li>vemail: <%=FP_FieldVal(fp_rs,"vemail")%></li>
<li>vcomments: <%=FP_FieldVal(fp_rs,"vcomments")%></li>
</ul>
<hr>

<hr>
 

<a href="vindex.htm">Return to
Index</a>
<a href="vsearch.asp">Return to Search
page</a>
 
 
</form>

</body>

</html>

THIS ONE WORKS FINE
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>Update Contract Records</title>
<meta name="Microsoft Theme" content="aftrnoon 1011, default">
</head>

<body>

Update Contract
Records

<% 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 ContractTable SET ExpirationDate ='::ExpirationDate::'
, StartRenewalProcessingDate =' ::StartRenewalProcessingDate::' ,
Comments = '::Comments::' WHERE (ID = ::ID:"
fp_sDefault="ExpirationDate=&StartRenewalProcessingDate=&Comments=&ID="
fp_sNoRecords="Your update request has been processed."
fp_sDataConn="vendorsandcontracts"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Comments=203&StartRenewalProcessingDate=135&ExpirationDate=135&ContractName=202&ID=3&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<hr>


<a href="vindex.htm">return to Index page</a>

</body>

</html>
Both are from the same database in fpdb just different tables.
I have tried everything. Any suggestions would be appreciated.

Click to expand...

I am trying to understand this code...	3	Jul 26, 2008
@ my wits end	1	Sep 12, 2006
Please help, FP generated code produces a "Too few parameters. Expected1" error!	7	Jun 6, 2005
Database Results Error	1	Sep 9, 2004
DataBase results Error continued	1	Sep 10, 2004
Drop down box query no.2	1	Dec 11, 2004
Problem with form validation	1	Jul 19, 2004
SELECT DISTINCT Query not working	4	Oct 24, 2004

any ideas why I can update one table in my database but not the other?

RasberryStolli

Andrew Murray

RasberryStolli

Ask a Question

Similar Threads