User Tools

Site Tools


zsqlextend_parameter

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:
<input type="hidden" name="sort" value="title">

or in the url of your resultpage, for example:
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

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: 2020/10/10 14:13 by 127.0.0.1