All numeric values problem in a drop down box

[chinkoh]

Hi

I am trying to add a drop down box to query a database. The field I am
querying is long integer. I created a form and inserted a DRW drop down
box with the following query:

SELECT DISTINCT fps_ FROM Videos

So now I have all the distinct entries in the drop dpwn box. I changed
the properties name to fps. Next I added a new entry in the form field
properties as All with the value of 1 OR 1.

On the same page, I inserted a DRW with the following query

SELECT * FROM Videos WHERE fps_ = ::fps::

I also set he default value for fps_ to be 1 OR 1.

This page was then saved as test.asp.
I ensured that the form for the drop down box would post to the same
page, test.asp.

However, when I select All in the drop down box, I get the following
error:

Database Results Wizard Error
Description: Parameter ?_1 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

Otherwise, if I select the other values in the drop box, everything
works fine.

I then inserted the following line to see what was in fps just before
the second DRW query:

<%response.write(request("fps"))%>

I get exactly what I expected, or that All is 1 OR 1. So this means
that the value is passing to the second DRW right?

When I manually set the second query to

SELECT * FROM Videos WHERE fps_ = 1 OR 1,

then I get all the results in the table?

Any ideas?

Thanks
Chin