Previous

TOC

Next

 
SEARCH/MODIFY

 

Search/modify function provides the ability to search records inside a table by giving search criteria, edit one by one selected group of records, delete selected group of records, insert new record into the table.

 

 -SEARCH RECORDS page displays the html forms against of  the column names, where the user inserts search criteria and chooses the display result options:
The following search criteria are available:


Search criteria

Match

NUMBER OF ARGUMENTS

 

The field contains the argument ('%argument%')

One (phrase)

Starts with

The field value starts with any argument ('arg1%' OR 'arg2%' OR 'arg3%', ...)

 

Ends with

The field value ends with any argument ('%arg1' OR '%arg2' OR '%arg3', ...)

 

AND

The field contains all the arguments ('%arg1%' AND '%arg2%' AND '%arg3%', ...)

Two or more

OR

The field contains any argument ('%arg1%' OR '%arg2%' OR '%arg3%', ...)

Two or more

>, <, =

Field value is more, less or equal to argument

One

BETWEEN

Field content is more or equal than first, and less or equal than second argument

Two

IN

match if the field content is one of the values in the list (val1, val2, val3 ...)

Two or more

NULL

Matched field should be NULL

No


NOTE: The arguments of Search pattern must be comma separated.

Search options:

'NOT' - inverts search criteria
'Match case' - performs case sensitive search (or binary)

NOTE:
'Match case' is supported by Mysql server of version 3.23.00 and higher. This option will not be displayed if the versiov of the installed Mysql server is prior 3.23.00

Display options:

'Sort by' - defines the column to sort the search result by,
'Sort order' - defines the displaying order - ascending or descending,
'Start' - defines the row number displaying the result will start from,
'Hits' - defines the number of displayed rows per page,
'
Show columns' - defines the columns that will be displayed in the search result.

SEARCH RESULT


'
Search result' page displays the table, consisting of n rows and columns.
Here we can select one or more rows to be edited or deleted, or print the result.
The user will be prompted to confirm the deletion of the selected rows.
If two or more rows are selected to be edited, the next row will be displayed on the 'Edit' page as the editing of the previous one is done,  until the last row is edited. The program will return back to the search result page then.

 


If the currently selected row should not be edited, just press SUBMIT button, the program will not generate the 'UPDATE statement if nothing was changed in the displayed fields. Or press "Back to search result" and select new set of rows to be edited.

Unquoted data checkboxes are used to insert SQL functions into the fields. For example, if we need to insert encrypted password into a field we must check the "Unquoted data" and then type PASSWORD('password') in the field form.

To print the result select the following printing options:
 - Print full result or displayed  hits only.
 - Enter the page title as the header of the printout.
 - Title text style (Bolt, Italic and Underlined).
 - Title alignment: Left, Right or Center.
 - Height of the table header and height of the table rows: (min., 20 pixel, 30 pixel).
 

 

Previous

TOC

Next