Search Form Question

  • Thread starter Thread starter Kristen Wagner
  • Start date Start date
K

Kristen Wagner

Hi All,

I have a FP2000 web page that displays all records from a SQL Server 2000
database table. The results are displayed in a table, one row per record,
with hyperlinks to edit, delete, browse, and sort the records according to
whichever field is desired. I'd like to add a search form to the page so
that users can type in a search string and retrieve matching records. The
page should open with all records returned as a default. What is the best
way to do this?

Thanks in advance,
Kristen Wagner
 
-----Original Message-----
Hi All,

I have a FP2000 web page that displays all records from a
SQL Server 2000 database table. The results are displayed
in a table, one row per record, with hyperlinks to edit,
delete, browse, and sort the records according to
whichever field is desired. I'd like to add a search form
to the page so that users can type in a search string and
retrieve matching records. The page should open with all
records returned as a default. What is the best way to do
this?

Thanks in advance,
Kristen Wagner
Click to expand...

On page 3 of the DRW, click More Options, then Critera,
then Add. Select the field you want to search on, set
Comparison to Equals, set value to the field name, and
select Use This Search Form Field. Then, click OK, OK, OK.

On page 5 of the DRW, select the Add Search Form check box.

See if that does what you want. If not, change the
Comaprison to Like and set a default value of %.

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) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
 
Jim,

That is pretty much what I ended up doing. I have a custom SQL script for
the clickable sort headings, so I had to add the additional criteria to that
code.

Thanks,
Kristen Wagner
 
Back
Top