Search?db=DatabaseName&search1data=xx&search2data=yy

Searches for matching records in a database and returns the found ones.

The search command looks through every record in the database and returns records matching the search criteria. It is extremely fast and flexible - you can search through multiple fields and sort the results in just about any way imagineable. The "matched" or "hit" records in the database are displayed in a [FoundItems] loop.

SQL/ODBC Note: To search through ODBC-compliant database, use the [SQL] context.

Searching can be very sophisticated, so we have dedicated a complete section to it here.

Example (normally you would link to a URL or form containing the following information):

http://yourserver.com/xx.tpl?command=Search&db=SomeDatabase.db&eqNAMEdata=Grant

The database "SomeDatabase.db" opens, all records whose name field is "Grant" found, and any [FoundItems]..[/FoundItems] contexts in the template xx.tpl filled with the list of found records.

Here are some equivalent ways to send the same command:

HTML Source	Description
<a href="xx.tpl?command=Search&db=SomeDatabase.db&eqNAMEdata=Grant">	Hyperlink command
<form method="POST" action="xx.tpl"> <input type="hidden" name="command" value="Search"> <input type="hidden" name="template" value="xx.tpl"> <input type="hidden" name="db" value="SomeDatabase.db"> <input name="eqNAMEdata" value="Grant"> <input type="submit"> </form>	Form-based command