Search Command

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

User Contributed Notes
SearchCommand  

Copyright © 2008 WebDNA Software Corporation, Inc.