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