drop down box problem repost

C

chinkoh

Hi

I am trying to add a numeric drop down box to query a database. 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
 

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