Search in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a search form in Frontpage that connects to an Access
database. How do I setup the search so that someone can type in parts of the
field and get a return of (instead of having to type in the exact word). For
example, I how like them to be able to type in a few letters and get a few
possible responses (ie type in the letters PA and get Paul, Pale etc).

Also, does Frontpage allow wildcards (ie *)?

Thanks...

Paul
 
For the SQL, you can make some changes. Normally, when matching exact
criteria, you would have fieldname = value. Instead of the equal, try using
LIKE. Also, the wildcards in SQL are different. A wildcard is a % for SQL
queries and not a *.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
 
PS
And if using the DBRW for the search form field, use LIKE for the criteria (not the = )

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| For the SQL, you can make some changes. Normally, when matching exact
| criteria, you would have fieldname = value. Instead of the equal, try using
| LIKE. Also, the wildcards in SQL are different. A wildcard is a % for SQL
| queries and not a *.
|
| Hope this helps,
| Mark Fitzpatrick
| Microsoft MVP - FrontPage
|
| | >I have created a search form in Frontpage that connects to an Access
| > database. How do I setup the search so that someone can type in parts of
| > the
| > field and get a return of (instead of having to type in the exact word).
| > For
| > example, I how like them to be able to type in a few letters and get a few
| > possible responses (ie type in the letters PA and get Paul, Pale etc).
| >
| > Also, does Frontpage allow wildcards (ie *)?
| >
| > Thanks...
| >
| > Paul
|
|
 
Back
Top