how to add an ALL VALUES option in a drop down list

[james]

Hi, All

I created two drop down boxes....
In the drop down lists, I'm trying to add an ALL VALUE
OPTION retrieving all records from the database.

I added "%" in the "specify value" to get all records.
But, It's still not working.

How can I fix it?

Thanks in advance..

 

[Jim Buyens]

-----Original Message-----

Hi, All
Howdy.

I created two drop down boxes....
In the drop down lists, I'm trying to add an ALL VALUE
OPTION retrieving all records from the database.

I added "%" in the "specify value" to get all records.
But, It's still not working.

You'll need to use a custom query, and in that query, use
a LIKE comparison operator rather than an equals sign.
So, for example, change

WHERE city = '::ddlCity::'

to

WHERE city LIKE '::ddlCity::'

Jim Buyens
MicrosJim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

oft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[james]

Do I have to change it in both drop down boxes?

-----Original Message-----

You'll need to use a custom query, and in that query, use
a LIKE comparison operator rather than an equals sign.
So, for example, change

WHERE city = '::ddlCity::'

to

WHERE city LIKE '::ddlCity::'

Jim Buyens
MicrosJim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

oft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------




.

 

[Jim Buyens]

Do I have to change it in both drop down boxes?

If both have an "all" option, then yes.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------