C
chinkoh
Hi
I am running frontpage 2003, access 2003, IIS 5.1.
I am trying to use dropdown boxes to effect a query. In the dropdown
boxes I have added an all values selection which uses the wild card %.
The problem is the numerical fields. I tried using 1 OR 1 as described
by the article http://support.microsoft.com/kb/825453, however this
does not work. I always get the following error:
Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine
If I run the query using one of the other values, then the table with
the correct values are shown.
I told that this may be a problem with my access table, so I used the
MS northwind database and followed the instructions word for word.
However, the same error occurrs.
Any insights on this problem is appreciated.
I am including the webbot code for the three main sections if it helps.
Thanks
Chin
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued"
s-columntypes="3,200,3,3,200,6,2,2,2,11" s-dataconnection="nwind"
b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="ProductName"
s-menuvalue="ProductID" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
s-displaycolumns="ProductID,ProductName" s-criteria s-order
s-sql="SELECT * FROM Products" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="0" botid="1"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color:
rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " startspan
--><!--#include file="_fpclass/fpdblib.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="51702"
--><select NAME="ProductID" SIZE="1">
<option selected value="1 OR 1">All Values</option>
<!--webbot bot="AspInclude" clientside
u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="62210" -->
<option
VALUE="<%=FP_FieldHTML(fp_rs,"ProductID")%>"><%=FP_FieldHTML(fp_rs,"ProductName")%>
</option>
<!--webbot bot="AspInclude" clientside
u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="62218" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" <span style="color: rgb(0,0,0);
background-color: rgb(255,255,0)">Results</span> "
startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --><p> </p>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued"
s-columntypes="3,200,3,3,200,6,2,2,2,11" s-dataconnection="nwind"
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="Products"
s-displaycolumns="ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued"
s-criteria="{ProductID} EQ {ProductID} +" s-order s-sql="SELECT * FROM
Products WHERE (ProductID = :roductID:" b-procedure="FALSE"
clientside suggestedext="asp" s-defaultfields="ProductID=1 OR 1"
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="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results
region. The page must be fetched from a web server with a web browser
to display correctly; the current web is stored on your local disk or
network.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
I am running frontpage 2003, access 2003, IIS 5.1.
I am trying to use dropdown boxes to effect a query. In the dropdown
boxes I have added an all values selection which uses the wild card %.
The problem is the numerical fields. I tried using 1 OR 1 as described
by the article http://support.microsoft.com/kb/825453, however this
does not work. I always get the following error:
Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine
If I run the query using one of the other values, then the table with
the correct values are shown.
I told that this may be a problem with my access table, so I used the
MS northwind database and followed the instructions word for word.
However, the same error occurrs.
Any insights on this problem is appreciated.
I am including the webbot code for the three main sections if it helps.
Thanks
Chin
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued"
s-columntypes="3,200,3,3,200,6,2,2,2,11" s-dataconnection="nwind"
b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="ProductName"
s-menuvalue="ProductID" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
s-displaycolumns="ProductID,ProductName" s-criteria s-order
s-sql="SELECT * FROM Products" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="0" botid="1"
u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color:
rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " startspan
--><!--#include file="_fpclass/fpdblib.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="51702"
--><select NAME="ProductID" SIZE="1">
<option selected value="1 OR 1">All Values</option>
<!--webbot bot="AspInclude" clientside
u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="62210" -->
<option
VALUE="<%=FP_FieldHTML(fp_rs,"ProductID")%>"><%=FP_FieldHTML(fp_rs,"ProductName")%>
</option>
<!--webbot bot="AspInclude" clientside
u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="62218" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" <span style="color: rgb(0,0,0);
background-color: rgb(255,255,0)">Results</span> "
startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --><p> </p>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued"
s-columntypes="3,200,3,3,200,6,2,2,2,11" s-dataconnection="nwind"
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="Products"
s-displaycolumns="ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued"
s-criteria="{ProductID} EQ {ProductID} +" s-order s-sql="SELECT * FROM
Products WHERE (ProductID = :roductID:" b-procedure="FALSE"
clientside suggestedext="asp" s-defaultfields="ProductID=1 OR 1"
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="<tr><td colspan=64
bgcolor="#FFFF00" width="100%"><font
color="#000000">This is the start of a Database Results
region. The page must be fetched from a web server with a web browser
to display correctly; the current web is stored on your local disk or
network.</font></td></tr>" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->