Please help, FP generated code produces a "Too few parameters. Expected1" error!

H

hmcclungiii

FP 2002, IIS.
I can't get past this error, everything else works fine!
-----------------------------------------------
Database Results Error
Description: Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine
-----------------------------------------------
Here is the code from the FP generated page ...

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>DrinkName</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="test.asp">
<table BORDER="0">
<tr>
<td><b>DrinkName</b></td>
<td>
<input TYPE="TEXT" NAME="DrinkName"
VALUE="<%=Request("DrinkName")%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --></p>
<p>&nbsp;</p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Name</b></td>
<td><b>Marked</b></td>
<td><b>GlassType</b></td>
<td><b>Description</b></td>
<td><b>Ingredient</b></td>
<td><b>MetricAmount</b></td>
<td><b>Amount</b></td>
<td><b>ID</b></td>
<td><b>Measure</b></td>
<td><b>Selected</b></td>
<td><b>Price</b></td>
<td><b>Cost</b></td>
<td><b>Type</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
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="TRUE" s-recordsource="DrinkLookup"
s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
suggestedext="asp" s-defaultfields="DrinkName=" 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="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. The region will not work unless the page has a file extension of
&quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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="DrinkLookup"
fp_sDefault="DrinkName="
fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=4
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="34095" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="3900" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="14177" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="15126" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="62813" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9640" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5024" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7359" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
--><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>

</body>

</html>

Please someone, help! This is going to put me into an early grave! :)

Thanks,
Houston
 
S

Stefan B Rusynko

<input TYPE="TEXT" NAME="DrinkName" VALUE="<%=Request("DrinkName")%>" size="20">
Is not FP generated code

There is no VBScript syntax that is just Request("")
If it is data from a form it is Request.Form("DrinkName")
If it is from a query (page parameters) it is Request.Query("DrinkName")

In either case the field name needs to be one that the DBR understands
Consider a dropdown list
See http://support.microsoft.com/kb/235554
For some tips on using the DBR see
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return



| FP 2002, IIS.
| I can't get past this error, everything else works fine!
| -----------------------------------------------
| Database Results Error
| Description: Too few parameters. Expected 1.
| Number: -2147217904 (0x80040E10)
| Source: Microsoft JET Database Engine
| -----------------------------------------------
| Here is the code from the FP generated page ...
|
| <html>
|
| <head>
| <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
| <meta name="ProgId" content="FrontPage.Editor.Document">
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
| <title>DrinkName</title>
| </head>
|
| <body>
|
| <form BOTID="0" METHOD="POST" ACTION="test.asp">
| <table BORDER="0">
| <tr>
| <td><b>DrinkName</b></td>
| <td>
| <input TYPE="TEXT" NAME="DrinkName"
| VALUE="<%=Request("DrinkName")%>" size="20"></td>
| </tr>
| </table>
| <p><br>
| <input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
| clientside suggestedext="asp" preview=" " --></p>
| <p>&nbsp;</p>
| </form>
| <table width="100%" border="1">
| <thead>
| <tr>
| <td><b>Name</b></td>
| <td><b>Marked</b></td>
| <td><b>GlassType</b></td>
| <td><b>Description</b></td>
| <td><b>Ingredient</b></td>
| <td><b>MetricAmount</b></td>
| <td><b>Amount</b></td>
| <td><b>ID</b></td>
| <td><b>Measure</b></td>
| <td><b>Selected</b></td>
| <td><b>Price</b></td>
| <td><b>Cost</b></td>
| <td><b>Type</b></td>
| </tr>
| </thead>
| <tbody>
| <!--webbot bot="DatabaseRegionStart"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
| 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="TRUE" s-recordsource="DrinkLookup"
| s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
| suggestedext="asp" s-defaultfields="DrinkName=" 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="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
| align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
| color=&quot;#000000&quot;&gt;This is the start of a Database Results
| region. The region will not work unless the page has a file extension of
| &quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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="DrinkLookup"
| fp_sDefault="DrinkName="
| fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=4
| fp_iPageSize=5
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=13
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="34095" --><tr>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="3900" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="14177" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="15126" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="62813" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="9640" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5024" --></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
| s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE"
| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
| --><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="7359" --></td>
| </tr>
| <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5"
| clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
| bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
| VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
| VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
| &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
| &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
| [1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
| --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
| </table>
|
| </body>
|
| </html>
|
| Please someone, help! This is going to put me into an early grave! :)
|
| Thanks,
| Houston
 
S

Stefan B Rusynko

Corrections
- you can use just Request but that forces ASP to cycle thru all Request objects until it find one that works w/ your field
(inefficient and a opens a door for sql injection
- the Request.Query should be Request.QueryString




| <input TYPE="TEXT" NAME="DrinkName" VALUE="<%=Request("DrinkName")%>" size="20">
| Is not FP generated code
|
| There is no VBScript syntax that is just Request("")
| If it is data from a form it is Request.Form("DrinkName")
| If it is from a query (page parameters) it is Request.Query("DrinkName")
|
| In either case the field name needs to be one that the DBR understands
| Consider a dropdown list
| See http://support.microsoft.com/kb/235554
| For some tips on using the DBR see
| http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| To find the best Newsgroup for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
| _____________________________________________
|
|
|| FP 2002, IIS.
|| I can't get past this error, everything else works fine!
|| -----------------------------------------------
|| Database Results Error
|| Description: Too few parameters. Expected 1.
|| Number: -2147217904 (0x80040E10)
|| Source: Microsoft JET Database Engine
|| -----------------------------------------------
|| Here is the code from the FP generated page ...
||
|| <html>
||
|| <head>
|| <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
|| <meta name="ProgId" content="FrontPage.Editor.Document">
|| <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|| <title>DrinkName</title>
|| </head>
||
|| <body>
||
|| <form BOTID="0" METHOD="POST" ACTION="test.asp">
|| <table BORDER="0">
|| <tr>
|| <td><b>DrinkName</b></td>
|| <td>
|| <input TYPE="TEXT" NAME="DrinkName"
|| VALUE="<%=Request("DrinkName")%>" size="20"></td>
|| </tr>
|| </table>
|| <p><br>
|| <input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
|| clientside suggestedext="asp" preview=" " --></p>
|| <p>&nbsp;</p>
|| </form>
|| <table width="100%" border="1">
|| <thead>
|| <tr>
|| <td><b>Name</b></td>
|| <td><b>Marked</b></td>
|| <td><b>GlassType</b></td>
|| <td><b>Description</b></td>
|| <td><b>Ingredient</b></td>
|| <td><b>MetricAmount</b></td>
|| <td><b>Amount</b></td>
|| <td><b>ID</b></td>
|| <td><b>Measure</b></td>
|| <td><b>Selected</b></td>
|| <td><b>Price</b></td>
|| <td><b>Cost</b></td>
|| <td><b>Type</b></td>
|| </tr>
|| </thead>
|| <tbody>
|| <!--webbot bot="DatabaseRegionStart"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
|| 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="TRUE" s-recordsource="DrinkLookup"
|| s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
|| suggestedext="asp" s-defaultfields="DrinkName=" 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="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
|| align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
|| color=&quot;#000000&quot;&gt;This is the start of a Database Results
|| region. The region will not work unless the page has a file extension of
|| &quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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="DrinkLookup"
|| fp_sDefault="DrinkName="
|| fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
|| returned.</td></tr>"
|| fp_sDataConn="Database1"
|| fp_iMaxRecords=256
|| fp_iCommandType=4
|| fp_iPageSize=5
|| fp_fTableFormat=True
|| fp_fMenuFormat=False
|| fp_sMenuChoice=""
|| fp_sMenuValue=""
|| fp_iDisplayCols=13
|| fp_fCustomQuery=False
|| BOTID=0
|| fp_iRegion=BOTID
|| %>
|| <!--#include file="../_fpclass/fpdbrgn1.inc"-->
|| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="34095" --><tr>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="3900" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="14177" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
|| bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
|| bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
|| bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
|| bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="15126" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
|| clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="62813" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
|| bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
|| bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="9640" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="5024" --></td>
|| <td>
|| <!--webbot bot="DatabaseResultColumn"
|| s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
|| s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE"
|| b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
|| size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
|| size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
|| --><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
|| endspan i-checksum="7359" --></td>
|| </tr>
|| <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
|| b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5"
|| clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
|| bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
|| VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
|| VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
|| &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
|| &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
|| [1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
|| --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
|| <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
|| </table>
||
|| </body>
||
|| </html>
||
|| Please someone, help! This is going to put me into an early grave! :)
||
|| Thanks,
|| Houston
|
|
 
H

hmcclungiii

Ummm, yessir, that entire excerpt is FP generated code.

As I duplicate the problem again, I'll write each step down as I do it ...

1) I launch FP, I am prompted for the username and password to my web
(residing on server)
2) I enter my username & password, check the 'Remember my password' box
(which incidentally never remembers my password :), and click the 'Ok'
button.
3) I click the 'File > New > Page or Web ...' menu item and the 'New
Page or Web' sidebar appears.
4) Under the section 'New' of the sidebar, I click 'Blank Page'. The
sidebar disappears, and the new page displays in 'Normal' mode.
5) In the menu bar, I select 'Insert > Database > Results ...'. The
Database Results Wizard appears on Step 1 of 5.
6) Since my existing database, 'Database1', is already selected in the
dropdown box, and the option to 'Use an existing database connection' is
already selected, I click the 'Next >' button.
7. Database Results Wizard - Step 2 of 5 ... The option 'Record
source:' is already selected, and all of the tables and queries in my
database are listed in the dropdown. I select the query 'DrinkLookup
(VIEW)' from the dropdown, and click the 'Next >' button.
8. Database Results Wizard - Step 3 of 5 ... All the fields from the
query are listed in the box, so I again click the 'Next >' button.
9. Database Results Wizard - Step 4 of 5 ... 'Table - one record per
row' selected in the dropdown box, all three checkboxes, 'Use table
border', 'Expand table to width of page', 'Include header row with
column labels', are checked. I click the 'Next >' button.
10. Database Results Wizard - Step 5 of 5 ... The option 'Split records
into groups:' is selected, with 5 'records per group'. The checkbox
'Add search form' is checked. I click the 'Finish' button.
11. Everything appears on the page in 'Normal' view, and when I click
'HTML', the following HTML does indeed appear, and when I open the page
in Internet Explorer or Mozilla, either one, I get that blasted error ...

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>New Page 1</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="new_page_1.htm">
<table BORDER="0">
<tr>
<td><b>DrinkName</b></td>
<td>
<input TYPE="TEXT" NAME="DrinkName"
VALUE="<%=Request("DrinkName")%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --></p>
<p>&nbsp;</p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Name</b></td>
<td><b>Marked</b></td>
<td><b>GlassType</b></td>
<td><b>Description</b></td>
<td><b>Ingredient</b></td>
<td><b>MetricAmount</b></td>
<td><b>Amount</b></td>
<td><b>ID</b></td>
<td><b>Measure</b></td>
<td><b>Selected</b></td>
<td><b>Price</b></td>
<td><b>Cost</b></td>
<td><b>Type</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
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="TRUE" s-recordsource="DrinkLookup"
s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
suggestedext="asp" s-defaultfields="DrinkName=" s-norecordsfound="No
records returned." i-maxrecords="256" i-groupsize="5" botid="0"
u-dblib="fpweb:///_fpclass/fpdblib.inc"
u-dbrgn1="fpweb:///_fpclass/fpdbrgn1.inc"
u-dbrgn2="fpweb:///_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. The region will not work unless the page has a file extension of
&quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
--><!--#include file="fpweb:///_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="DrinkLookup"
fp_sDefault="DrinkName="
fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=4
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="fpweb:///_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="35585" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="3900" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="14177" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="15126" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="62813" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9640" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5024" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7359" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="fpweb:///_fpclass/fpdbrgn2.inc"
i-groupsize="5" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
--><!--#include file="fpweb:///_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="23298" --></tbody>
</table>

</body>

</html>

Any help GREATLY appreciated,

Thanks again,
Houston
 
H

hmcclungiii

Furthermore, the name of the Query in the Table is 'DrinkName'. When
this query appears in the dropdown of the 'Database Results Wizard -
Step 2 of 5', it is suffixed by (VIEW). Any query suffixed by (VIEW) in
this dropdown, when used to generate a page, reproduces the error. If
it is not suffixed by (VIEW), the page works.

Just a note, I am creating a new, blank page, and running the Database
Results Wizard. I add nothing to the page afterwards, and I get this
error. Shouldn't FrontPage generate proper script?

Running out of time on this problem, anything you can offer would be
greatly appreciated.

Thanks again for any help, advice, assistance.

Houston
FP 2002, IIS.
I can't get past this error, everything else works fine!
-----------------------------------------------
Database Results Error
Description: Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine
-----------------------------------------------
Here is the code from the FP generated page ...

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>DrinkName</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="test.asp">
<table BORDER="0">
<tr>
<td><b>DrinkName</b></td>
<td>
<input TYPE="TEXT" NAME="DrinkName"
VALUE="<%=Request("DrinkName")%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --></p>
<p>&nbsp;</p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Name</b></td>
<td><b>Marked</b></td>
<td><b>GlassType</b></td>
<td><b>Description</b></td>
<td><b>Ingredient</b></td>
<td><b>MetricAmount</b></td>
<td><b>Amount</b></td>
<td><b>ID</b></td>
<td><b>Measure</b></td>
<td><b>Selected</b></td>
<td><b>Price</b></td>
<td><b>Cost</b></td>
<td><b>Type</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
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="TRUE" s-recordsource="DrinkLookup"
s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
suggestedext="asp" s-defaultfields="DrinkName=" 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="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. The region will not work unless the page has a file extension of
&quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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="DrinkLookup"
fp_sDefault="DrinkName="
fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=4
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="34095" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="3900" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="14177" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="15126" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="62813" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="9640" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5024" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7359" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
--><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>

</body>

</html>

Please someone, help! This is going to put me into an early grave! :)

Thanks,
Houston
 
H

hmcclungiii

IOW, I can't seem to use a query, instead of a table, from my database
in the 'Database Results Wizard - Step 2 of 5'.
Furthermore, the name of the Query in the Table is 'DrinkName'. When
this query appears in the dropdown of the 'Database Results Wizard -
Step 2 of 5', it is suffixed by (VIEW). Any query suffixed by (VIEW) in
this dropdown, when used to generate a page, reproduces the error. If
it is not suffixed by (VIEW), the page works.

Just a note, I am creating a new, blank page, and running the Database
Results Wizard. I add nothing to the page afterwards, and I get this
error. Shouldn't FrontPage generate proper script?

Running out of time on this problem, anything you can offer would be
greatly appreciated.

Thanks again for any help, advice, assistance.

Houston
FP 2002, IIS.
I can't get past this error, everything else works fine!
-----------------------------------------------
Database Results Error
Description: Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine
-----------------------------------------------
Here is the code from the FP generated page ...

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>DrinkName</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="test.asp">
<table BORDER="0">
<tr>
<td><b>DrinkName</b></td>
<td>
<input TYPE="TEXT" NAME="DrinkName"
VALUE="<%=Request("DrinkName")%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --></p>
<p>&nbsp;</p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Name</b></td>
<td><b>Marked</b></td>
<td><b>GlassType</b></td>
<td><b>Description</b></td>
<td><b>Ingredient</b></td>
<td><b>MetricAmount</b></td>
<td><b>Amount</b></td>
<td><b>ID</b></td>
<td><b>Measure</b></td>
<td><b>Selected</b></td>
<td><b>Price</b></td>
<td><b>Cost</b></td>
<td><b>Type</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
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="TRUE" s-recordsource="DrinkLookup"
s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
suggestedext="asp" s-defaultfields="DrinkName=" 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="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot;
align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. The region will not work unless the page has a file extension
of &quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" 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="DrinkLookup"
fp_sDefault="DrinkName="
fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=4
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="34095" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="3900" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14177" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15126" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="62813" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Price")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="9640" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5024" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Type")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7359" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc"
i-groupsize="5" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;
&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
--><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>

</body>

</html>

Please someone, help! This is going to put me into an early grave! :)

Thanks,
Houston
 
K

Kathleen Anderson [MVP - FrontPage]

If your search/dropdown is on on the same page as your database results,
when the page is loaded, the database results is going to try and run the
search - if you haven't given it a default value, it's going to fail. I
would recommend putting the search/dropdown on one page, and have it pass
the value to a second page. Did you look at the link that Stefan posted?
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


hmcclungiii said:
Furthermore, the name of the Query in the Table is 'DrinkName'. When this
query appears in the dropdown of the 'Database Results Wizard - Step 2 of
5', it is suffixed by (VIEW). Any query suffixed by (VIEW) in this
dropdown, when used to generate a page, reproduces the error. If it is
not suffixed by (VIEW), the page works.

Just a note, I am creating a new, blank page, and running the Database
Results Wizard. I add nothing to the page afterwards, and I get this
error. Shouldn't FrontPage generate proper script?

Running out of time on this problem, anything you can offer would be
greatly appreciated.

Thanks again for any help, advice, assistance.

Houston
FP 2002, IIS.
I can't get past this error, everything else works fine!
-----------------------------------------------
Database Results Error
Description: Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine
-----------------------------------------------
Here is the code from the FP generated page ...

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>DrinkName</title>
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="test.asp">
<table BORDER="0">
<tr>
<td><b>DrinkName</b></td>
<td>
<input TYPE="TEXT" NAME="DrinkName"
VALUE="<%=Request("DrinkName")%>" size="20"></td>
</tr>
</table>
<p><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --></p>
<p>&nbsp;</p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Name</b></td>
<td><b>Marked</b></td>
<td><b>GlassType</b></td>
<td><b>Description</b></td>
<td><b>Ingredient</b></td>
<td><b>MetricAmount</b></td>
<td><b>Amount</b></td>
<td><b>ID</b></td>
<td><b>Measure</b></td>
<td><b>Selected</b></td>
<td><b>Price</b></td>
<td><b>Cost</b></td>
<td><b>Type</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-columntypes="202,11,202,203,202,202,202,3,4,11,6,6,202"
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="TRUE" s-recordsource="DrinkLookup"
s-displaycolumns="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-criteria s-order s-sql="DrinkLookup" b-procedure="TRUE" clientside
suggestedext="asp" s-defaultfields="DrinkName=" 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="&lt;tr&gt;&lt;td
colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot;
width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
the start of a Database Results region. The region will not work unless
the page has a file extension of
&quot;.asp&quot;.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;"
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="DrinkLookup"
fp_sDefault="DrinkName="
fp_sNoRecords="<tr><td colspan=13 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=4
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="34095" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="3900" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Marked" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marked&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Marked")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14177" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="GlassType" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;GlassType&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"GlassType")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19667" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Description&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Ingredient" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ingredient&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Ingredient")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30988" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="MetricAmount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;MetricAmount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"MetricAmount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32543" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Amount" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Amount&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Amount")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15126" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ID&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="62813" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Measure" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Measure&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Measure")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="12830" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Selected" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Selected&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Selected")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15416" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Price&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="9640" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Cost" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Cost&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Cost")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="5024" --></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Name,Marked,GlassType,Description,Ingredient,MetricAmount,Amount,ID,Measure,Selected,Price,Cost,Type"
s-column="Type" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Type&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Type")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="7359" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; align=&quot;left&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;&lt;TR&gt;&lt;TD ALIGN=LEFT
VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button
VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt;
&quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT
TYPE=Button VALUE=&quot; &gt;| &quot;&gt;
[1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;"
startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>

</body>

</html>

Please someone, help! This is going to put me into an early grave! :)

Thanks,
Houston
 
H

hmcclungiii

Yes I did that too.

I also gave it a default.

When I enter a valid value, and click the 'Submit Query' button, it
still causes the error.

Nothing works. Keep getting that error.

Very strange. Only happens on queries, not tables. If I do the same
with a table, it works fine.

Also, just to be sure, I used Access to validate that the query works.

For all reasons and purposes, it should work :(

Desparate, and resultless,
Houston
 

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