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


R

RasberryStolli

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">
<p><font size="6" color="#703637"><b>Vendor search
results</b></font></p>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202"
s-dataconnection="vendorsandcontracts" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice="VID" s-menuvalue="VID"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="2"
b-makeform="FALSE" s-recordsource="VENDORS"
s-displaycolumns="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-criteria="[vname] CNT {vname} +" s-order s-sql="SELECT * FROM VENDORS
WHERE (vname LIKE '%::vname::%')" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields="vname=" s-norecordsfound="NO VENDOR
INFORMATION FOUND!!!!!!!!!!" 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="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="202"
b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="202"
b-WasTableFormat="FALSE" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55160" --><ul>
<li><b>VID:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="VID" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;VID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"VID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="65113" --></li>
<li><b>vname:</b>&nbsp;<a
href="vupdate.asp?vname=<%=FP_FieldURL(fp_rs,"vname")%>"><!--webbot
bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,202,202"
startspan --><%=FP_FieldVal(fp_rs,"vname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="11572" --></a>Click
here to update Vendor data</li>
<li><b>vfirstname:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vfirstname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vfirstname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vfirstname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30998" --></li>
<li><b>vlastname:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vlastname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vlastname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vlastname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22407" --></li>
<li><b>vstreetaddress:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vstreetaddress" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vstreetaddress&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vstreetaddress")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="44985" --></li>
<li><b>vcity:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vcity" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vcity&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vcity")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="10266" --></li>
<li><b>vstate:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vstate" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vstate&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vstate")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19155" --></li>
<li><b>vzip:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vzip" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vzip&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vzip")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9678" --></li>
<li><b>vphone:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vphone" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vphone&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vphone")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="18763" --></li>
<li><b>vext:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vext" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vext&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vext")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7013" --></li>
<li><b>vfax:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vfax" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vfax&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vfax")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7126" --></li>
<li><b>vemail:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vemail" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vemail&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vemail")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="17368" --></li>
<li><b>vcomments:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vcomments" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vcomments&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vcomments")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22485" --></li>
</ul>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><hr>
<p>&nbsp;</p>
<p>
<font size="4" color="#703637"><b><a href="vindex.htm">Return to
Index</a></b></font></p>
<p><font size="4"><b><a href="vsearch.asp">Return to Search
page</a></b></font></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</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>

<p><font size="5" color="#703637"><b>Update Contract
Records</b></font></p>
<!--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;amp;StartRenewalProcessingDate=&amp;amp;Comments=&amp;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="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE"
--><!--#include file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="12677" --><hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><p>
<a href="vindex.htm">return to Index page</a></p>

</body>

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

Advertisements

A

Andrew Murray

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">
<p><font size="6" color="#703637"><b>Vendor search
results</b></font></p>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202"
s-dataconnection="vendorsandcontracts" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice="VID" s-menuvalue="VID"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="2"
b-makeform="FALSE" s-recordsource="VENDORS"
s-displaycolumns="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-criteria="[vname] CNT {vname} +" s-order s-sql="SELECT * FROM VENDORS
WHERE (vname LIKE '%::vname::%')" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields="vname=" s-norecordsfound="NO VENDOR
INFORMATION FOUND!!!!!!!!!!" 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="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="202"
b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="202"
b-WasTableFormat="FALSE" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55160" --><ul>
<li><b>VID:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="VID" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;VID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"VID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="65113" --></li>
<li><b>vname:</b>&nbsp;<a
href="vupdate.asp?vname=<%=FP_FieldURL(fp_rs,"vname")%>"><!--webbot
bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,202,202"
startspan --><%=FP_FieldVal(fp_rs,"vname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="11572" --></a>Click
here to update Vendor data</li>
<li><b>vfirstname:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vfirstname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vfirstname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vfirstname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30998" --></li>
<li><b>vlastname:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vlastname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vlastname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vlastname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22407" --></li>
<li><b>vstreetaddress:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vstreetaddress" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vstreetaddress&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vstreetaddress")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="44985" --></li>
<li><b>vcity:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vcity" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vcity&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vcity")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="10266" --></li>
<li><b>vstate:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vstate" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vstate&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vstate")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19155" --></li>
<li><b>vzip:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vzip" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vzip&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vzip")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9678" --></li>
<li><b>vphone:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vphone" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vphone&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vphone")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="18763" --></li>
<li><b>vext:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vext" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vext&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vext")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7013" --></li>
<li><b>vfax:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vfax" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vfax&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vfax")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7126" --></li>
<li><b>vemail:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vemail" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vemail&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vemail")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="17368" --></li>
<li><b>vcomments:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vcomments" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vcomments&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vcomments")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22485" --></li>
</ul>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><hr>
<p>&nbsp;</p>
<p>
<font size="4" color="#703637"><b><a href="vindex.htm">Return to
Index</a></b></font></p>
<p><font size="4"><b><a href="vsearch.asp">Return to Search
page</a></b></font></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</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>

<p><font size="5" color="#703637"><b>Update Contract
Records</b></font></p>
<!--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;amp;StartRenewalProcessingDate=&amp;amp;Comments=&amp;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="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE"
--><!--#include file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="12677" --><hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><p>
<a href="vindex.htm">return to Index page</a></p>

</body>

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

Advertisements

R

RasberryStolli

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">
<p><font size="6" color="#703637"><b>Vendor search
results</b></font></p>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202"
s-dataconnection="vendorsandcontracts" b-tableformat="FALSE"
b-menuformat="FALSE" s-menuchoice="VID" s-menuvalue="VID"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="2"
b-makeform="FALSE" s-recordsource="VENDORS"
s-displaycolumns="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-criteria="[vname] CNT {vname} +" s-order s-sql="SELECT * FROM VENDORS
WHERE (vname LIKE '%::vname::%')" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields="vname=" s-norecordsfound="NO VENDOR
INFORMATION FOUND!!!!!!!!!!" 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="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="202"
b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="202"
b-WasTableFormat="FALSE" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55160" --><ul>
<li><b>VID:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="VID" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;VID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"VID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="65113" --></li>
<li><b>vname:</b>&nbsp;<a
href="vupdate.asp?vname=<%=FP_FieldURL(fp_rs,"vname")%>"><!--webbot
bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,202,202"
startspan --><%=FP_FieldVal(fp_rs,"vname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="11572" --></a>Click
here to update Vendor data</li>
<li><b>vfirstname:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vfirstname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vfirstname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vfirstname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30998" --></li>
<li><b>vlastname:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vlastname" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vlastname&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vlastname")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22407" --></li>
<li><b>vstreetaddress:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vstreetaddress" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vstreetaddress&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vstreetaddress")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="44985" --></li>
<li><b>vcity:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vcity" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vcity&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vcity")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="10266" --></li>
<li><b>vstate:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vstate" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vstate&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vstate")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19155" --></li>
<li><b>vzip:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vzip" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vzip&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vzip")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9678" --></li>
<li><b>vphone:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vphone" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vphone&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vphone")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="18763" --></li>
<li><b>vext:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vext" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vext&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vext")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7013" --></li>
<li><b>vfax:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vfax" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vfax&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vfax")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7126" --></li>
<li><b>vemail:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vemail" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vemail&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vemail")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="17368" --></li>
<li><b>vcomments:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
s-columnnames="VID,vname,vfirstname,vlastname,vstreetaddress,vcity,vstate,vzip,vphone,vext,vfax,vemail,vcomments"
s-column="vcomments" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;vcomments&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"vcomments")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="22485" --></li>
</ul>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><hr>
<p>&nbsp;</p>
<p>
<font size="4" color="#703637"><b><a href="vindex.htm">Return to
Index</a></b></font></p>
<p><font size="4"><b><a href="vsearch.asp">Return to Search
page</a></b></font></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</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>

<p><font size="5" color="#703637"><b>Update Contract
Records</b></font></p>
<!--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;amp;StartRenewalProcessingDate=&amp;amp;Comments=&amp;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="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE"
--><!--#include file="_fpclass/fpdblib.inc"-->
<% 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
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="12677" --><hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" startspan
--><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><p>
<a href="vindex.htm">return to Index page</a></p>

</body>

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top