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

hmcclungiii · Jun 6, 2005

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"></p>
<p> </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>

<% 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
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Marked")%></td>
<td>
<%=FP_FieldVal(fp_rs,"GlassType")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Description")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Ingredient")%></td>
<td>
<%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Amount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Measure")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Selected")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Price")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Cost")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Type")%></td>
</tr>

</tbody>
</table>

</body>

</html>

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

Thanks,
Houston

Stefan B Rusynko · Jun 7, 2005

<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"></p>
| <p> </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>
| 
| <% 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
| %>
| 
| <tr>
| <td>
| <%=FP_FieldVal(fp_rs,"Name")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Marked")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"GlassType")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Description")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Ingredient")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Amount")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"ID")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Measure")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Selected")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Price")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Cost")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Type")%></td>
| </tr>
| 
| </tbody>
| </table>
|
| </body>
|
| </html>
|
| Please someone, help! This is going to put me into an early grave!

|
| Thanks,
| Houston

Stefan B Rusynko · Jun 7, 2005

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"></p>
|| <p> </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>
|| 
|| <% 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
|| %>
|| 
|| <tr>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Name")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Marked")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"GlassType")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Description")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Ingredient")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Amount")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"ID")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Measure")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Selected")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Price")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Cost")%></td>
|| <td>
|| <%=FP_FieldVal(fp_rs,"Type")%></td>
|| </tr>
|| 
|| </tbody>
|| </table>
||
|| </body>
||
|| </html>
||
|| Please someone, help! This is going to put me into an early grave!

||
|| Thanks,
|| Houston
|
|

hmcclungiii · Jun 8, 2005

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"></p>
<p> </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>

<% 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
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Marked")%></td>
<td>
<%=FP_FieldVal(fp_rs,"GlassType")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Description")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Ingredient")%></td>
<td>
<%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Amount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Measure")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Selected")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Price")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Cost")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Type")%></td>
</tr>

</tbody>
</table>

</body>

</html>

Any help GREATLY appreciated,

Thanks again,
Houston

hmcclungiii · Jun 9, 2005

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"></p>
<p> </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>

<% 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
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Marked")%></td>
<td>
<%=FP_FieldVal(fp_rs,"GlassType")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Description")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Ingredient")%></td>
<td>
<%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Amount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Measure")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Selected")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Price")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Cost")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Type")%></td>
</tr>

</tbody>
</table>

</body>

</html>

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

Thanks,
Houston

hmcclungiii · Jun 9, 2005

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"></p>
<p> </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>

<% 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
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Marked")%></td>
<td>
<%=FP_FieldVal(fp_rs,"GlassType")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Description")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Ingredient")%></td>
<td>
<%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Amount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Measure")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Selected")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Price")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Cost")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Type")%></td>
</tr>

</tbody>
</table>

</body>

</html>

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

Thanks,
Houston

Click to expand...

Kathleen Anderson [MVP - FrontPage] · Jun 9, 2005

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"></p>
<p> </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>

<% 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
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Name")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Marked")%></td>
<td>
<%=FP_FieldVal(fp_rs,"GlassType")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Description")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Ingredient")%></td>
<td>
<%=FP_FieldVal(fp_rs,"MetricAmount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Amount")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ID")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Measure")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Selected")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Price")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Cost")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Type")%></td>
</tr>

</tbody>
</table>

</body>

</html>

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

Thanks,
Houston

Click to expand...

hmcclungiii · Jun 9, 2005

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

I am trying to understand this code...	3	Jul 26, 2008
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
Database Results Error	1	Sep 9, 2004
@ my wits end	1	Sep 12, 2006
DataBase results Error continued	1	Sep 10, 2004
Problem with form validation	1	Jul 19, 2004
Drop down box query no.2	1	Dec 11, 2004
Webbot FP_FieldLink FP_FeidlVal question	3	Mar 17, 2004

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

hmcclungiii

Stefan B Rusynko

Stefan B Rusynko

hmcclungiii

hmcclungiii

hmcclungiii

Kathleen Anderson [MVP - FrontPage]

hmcclungiii

Ask a Question

Similar Threads