User Tools

Site Tools


zsqlextend_parameter

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

zsqlextend_parameter [2006/11/01 11:36] (current)
Line 1: Line 1:
 +=== Parameters for ZSQLSearch and ZSQLFind ===
 +
 +You can specify various parameter for your search. E.g. the sortorder, the operator for the fields, the number of shown results etc.
 +
 +You can do this in your web-form, for example:\\
 +''<​nowiki><​input type="​hidden"​ name="​sort"​ value="​title"></​nowiki>''​
 +
 +or in the url of your resultpage, for example:\\
 +''<​nowiki>​http://​echo2.mpiwg-berlin.mpg.de/​content/​relativityrevolution/​gehrcke/​newspaper_articles/​gehrcke_database/​results_short.html?​-table=gehrcke_collection&​-lop=and&​-op_titel=all&​Titel=einstein&​-max=50&​-sort=titel&​-sortorder=ASC&​-find%3D=Search</​nowiki>''​
 +
 +
 +== table ==
 +
 +Defines the table to be searched.
 +
 +== sort ==
 +
 +Defines the field for sorting.
 +
 +== sortorder ==
 +
 +Defines the sortorder. Can have the value ASC (ascending) or DESC (descending). ​
 +
 +== lop ==
 +
 +Defines how the fields are combined. The value can be AND or OR.
 +
 +== op_fieldname ==
 +
 +Defines how the content in a field (defined by ''​fieldname''​) is combined. Can have the following values:\\
 +''​all''​ - the field must contain all entered words\\
 +''​one''​ - the field must contain at least one entered word\\
 +''​ct''​ - the field must contain exactly what is entered\\
 +''​bw''​ - the field begins with what is entered\\
 +''​ew''​ - the field ends with what is entered\\
 +''​eq''​ - the field is exaclty the same as what is entered
 +
 +== max ==
 +
 +The number of records per page.
 +
 +
 +
 +
 +
 +
 +
 +
  
zsqlextend_parameter.txt · Last modified: 2006/11/01 11:36 (external edit)