SEARCH screens are used to modify or refine the selection criteria used by LIST screens.
$wherestring. This behaviour may be altered by specifying values for either of the Selection fields which are described in Appendix D.
$wherestring from the parent screen.
Within each LIST screen you may see the following buttons:
$searchvariable to be reloaded with the previous search criteria for this database table, and fresh data will be retrieved from the database using the combined contents of the
$orderbyvariables and read fresh data from the database using the contents of the
Within LIST screens there may also be any of the following options which will affect how the data is retrieved from the database and displayed:
$orderbyvariable and fresh data to be retrieved using that column name in the ORDER BY clause of the sql SELECT statement. A symbol will then appear next to the column name to indicate that the data was sorted on that column. The sequence will toggle between 'ascending' and 'descending' when any of these hyperlinks is pressed, and the symbol will change accordingly. Note that the sort is not limited to the data within the current screen - it will cause a fresh set of data to be retrieved from the database which may cause any or all of the current rows to disappear completely from the display.
When a SEARCH screen is activated anything passed down in the
$where string will be shown in the screen as read-only and will not be able to be amended. Any previous search criteria used for this database table will be shown and will be able to be amended. Within this screen you may see the following buttons:
$searchstring. Instead of using the format
fieldname='value'which requires an exact match the format
fieldname LIKE 'value'will be used instead. This allows for the wildcard character '%' to be used anywhere within a string field. The
$searchstring will then be inserted in the session data for the previous script which will then be reactivated using the header() function. When the script runs it will combine the contents of any
$searchstrings before reading fresh data from the database.
$searchvariable, but will leave the