SQL Query

K

kevwash

Is there a way to pass a "specific" or "all values" to the "Database
Results". Example;

Field "AREA" has Home, Work, Etc

I choose one of these values or I choose a "blank" value. This "blank" value
will tell the "Database Results" to return "all values" from that field
 
J

Jens Peter Karlsen[FP MVP]

You use a * to get all values.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
J

Jim Buyens

Assuming you're using the Database Results Wizard, code:

WHERE AREA Like('%%area%%*')

where area is the name of your form field. However, keep in mind that town*
matches both town and township.

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