All values item in a dropdown box for numeric field query

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=" &lt;span style=&quot;color:
rgb(0,0,0); background-color:
rgb(255,255,0)&quot;&gt;Database&lt;/span&gt; " 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=" &lt;span style=&quot;color: rgb(0,0,0);
background-color: rgb(255,255,0)&quot;&gt;Results&lt;/span&gt; "
startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></td>
</tr>
</table>
<br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --><p>&nbsp;</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 = ::productID::)" 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="&lt;tr&gt;&lt;td colspan=64
bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font
color=&quot;#000000&quot;&gt;This is the start of a Database Results
region. 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.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="_fpclass/fpdblib.inc"-->
 

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