Update Query

[Bill]

I am using FrontPage 2003 and trying to run an update
query to an Access Database located in the website. I
get the following error message but when I search for the
article in the Knowledge Base it says it does not exist.

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.

Any assistance would be greatly appreciated.

Thanks
Bill

 

[MD WebsUnlimited.com]

Hi Bill,

To debunk this the page source would be required.

 

[Guest]

Thanks for your help. Following is the source for the
update page. The query is supposed to update 20 fields.
Those named "::Fund::" are text in the database and those
with the name ::Split:: are numeric fields in the
database.

Bill



<script Language="JavaScript">

</script>

<!--webbot bot="DatabaseRegionStart" s-columnnames s-
columntypes s-dataconnection="TimeSheet" 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 Effort_Reporting SET Effort_Reporting.Fund1
= '::fund1::', Effort_Reporting.Fund2 = '::fund2::',
Effort_Reporting.Fund3 = '::fund3::',
Effort_Reporting.Fund4 = '::fund4::',
Effort_Reporting.Fund5 = '::fund5::',
Effort_Reporting.Fund6 = '::fund6::',
Effort_Reporting.Fund7 = '::fund7::',
Effort_Reporting.Fund8 = '::fund8::',
Effort_Reporting.Fund9 = '::fund9::',
Effort_Reporting.Fund10 = '::fund10::',
Effort_Reporting.Split1 = ::Split1::,
Effort_Reporting.Split2 = ::Split2::,
Effort_Reporting.Split3 = ::Split3::,
Effort_Reporting.Split4 = ::Split4::,
Effort_Reporting.Split5 = ::Split5::,
Effort_Reporting.Split6 = ::Split6::,
Effort_Reporting.Split7 = ::Split7::,
Effort_Reporting.Split8 = ::Split8::,
Effort_Reporting.Split9 = ::Split9::,
Effort_Reporting.Split10 = ::Split10:: &lt;br&gt;WHERE
(((Effort_Reporting.[ID])=::ID:);" b-procedure="FALSE"
clientside suggestedext="asp" s-
defaultfields="fund1=&amp;amp;fund2=&amp;amp;fund3=&amp;am
p;fund4=&amp;amp;fund5=&amp;amp;fund6=&amp;amp;fund7=&amp;
amp;fund8=&amp;amp;fund9=&amp;amp;fund10=&amp;amp;Split1=&
amp;amp;Split2=&amp;amp;Split3=&amp;amp;Split4=&amp;amp;Sp
lit5=&amp;amp;Split6=&amp;amp;Split7=&amp;amp;Split8=&amp;
amp;Split9=&amp;amp;Split10=&amp;amp;ID=" s-
norecordsfound="Update complete for current pay period.
For permanent changes submit an ECF." i-maxrecords="256"
i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-
dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%
&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;" startspan b-
UseDotNET="FALSE" CurrentExt sa-InputTypes b-
DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-
CritTypes b-WasTableFormat="TRUE" --><!--#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 Effort_Reporting SET
Effort_Reporting.Fund1 = '::fund1::',
Effort_Reporting.Fund2 = '::fund2::',
Effort_Reporting.Fund3 = '::fund3::',
Effort_Reporting.Fund4 = '::fund4::',
Effort_Reporting.Fund5 = '::fund5::',
Effort_Reporting.Fund6 = '::fund6::',
Effort_Reporting.Fund7 = '::fund7::',
Effort_Reporting.Fund8 = '::fund8::',
Effort_Reporting.Fund9 = '::fund9::',
Effort_Reporting.Fund10 = '::fund10::',
Effort_Reporting.Split1 = ::Split1::,
Effort_Reporting.Split2 = ::Split2::,
Effort_Reporting.Split3 = ::Split3::,
Effort_Reporting.Split4 = ::Split4::,
Effort_Reporting.Split5 = ::Split5::,
Effort_Reporting.Split6 = ::Split6::,
Effort_Reporting.Split7 = ::Split7::,
Effort_Reporting.Split8 = ::Split8::,
Effort_Reporting.Split9 = ::Split9::,
Effort_Reporting.Split10 = ::Split10:: WHERE
(((Effort_Reporting.[ID])=::ID:);"
fp_sDefault="fund1=&fund2=&fund3=&fund4=&fund5=&fund6=&fun
d7=&fund8=&fund9=&fund10=&Split1=&Split2=&Split3=&Split4=&
Split5=&Split6=&Split7=&Split8=&Split9=&Split10=&ID="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT""
width=""100%"">Update complete for current pay period.
For permanent changes submit an ECF.</td></tr>"
fp_sDataConn="TimeSheet"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-
CheckSum="45892" --><!--webbot bot="DatabaseRegionEnd" b-
tableformat="TRUE" b-menuformat="FALSE" u-
dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%
&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;" startspan --

<!--#include file="_fpclass/fpdbrgn2.inc"-->

<!--webbot bot="DatabaseRegionEnd" endspan i-
CheckSum="62730" --></tbody>
</body>

 

[Cory]

I am having the same issue using the FP2003 DIW. I
noticed that when created the DIW the list.asp page does
not display all the fields. Please let me know if you
get any feedback regarding the issue.