How to set the value in a drop-down box to retrieve all records

[Lila]

I am using a drop-down box to collect information that I
then use to retrieve records from a database. It works
fine when I set the "value" to a specific entry in
the database field. But what do I use for the "value"
when I want to retrieve all records from a field?

I am using FrontPage 2002 published to a server provided
by an ISP.

Thanks.
Lila

 

[Kevin Spencer]

It depends on the data type of the field. If it is a string (text), it's a
simple matter of putting the value "%" into its value. The "%" character is
the wildcard character for SQL, which means that it will filter out no
records. If it's a number or date, you're in some trouble, as you will need
to do some custom programming to change the query.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Lila]

Kevin,

The data type of the field is text. I tried using "%" (both with and
without quotes) and still got no records. Again it worked when the
"value" was set equal to a specific entry. Any other suggestons?

Thanks,
Lila