SQL help again

[JB]

I still can't get it to work. What is the best way to
right an SQL statement in frontpage database results to
use the pick list?
ICKLIST:
Desk
Chairs
ALL

what is the best way to get the ALL button to pull both
chairs and Desk. I tried to enter the value for ALL as %
but that don't work.
Please help
Thanks

 

[Jim Buyens]

Assuming PICKLIST is the name of your form field, try:

(furntype LIKE(":ICKLIST::"))

rather than

(furntype = ':ICKLIST::')

and then assigning a value of * or % to the choice for
All. (The choice of * or % depends on your database.)

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
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) ||
|/----------------------------------------------------\|
*------------------------------------------------------*