By default the ASP returns all records from the table. You can however get only a page of records at a time by specifying a page size.

Example
If you use *.asp?pagesize=3, only 3 records will be returned. If pageno (see below) is not specified, the first page will be returned.

Specifies the page number of records if paging is used. This parameter has no effect is pagesize is not specified.

Example
If you use *.asp?pagesize=3&pageno=2, record 4-6 will be returned

Specifies the starting record.

Example
If you use *.asp?pagesize=3&start=2, record 2-4 will be returned. If you don't specify a page size, all records from the starting record will return.

Specifies the Quick Search criteria. The fields to be searched are determined by the "Quick Search" setting in Field Setup page.

Note: Parameters should be URL-encoded, for example, the spaces between words become "+" after encoded.

Example
If you use *.asp?search=12+ab, all records with fields equals to or contains "12 ab" will be returned.

Specifies the Quick Search type if the search criteria contains more than one words. Support types are "AND" (all words) or "OR" (any words).

Example
If you use *.asp?search=12+ab&searchtype=AND, all records with fields equals to or contains "12" and "ab" will be returned.

Specifies the field to sort. Multiple sorting fields separated by comma are supported.

Note: Parameters should be URL-encoded, for example, if the field name contain spaces, the spaces become "+" after encoded.

Example
If you use *.asp?sort=ID, the records will be sorted by ID. (ORDER BY ID)
If you use *.asp?sort=ID,Name, the records will be sorted by ID and then by Name. (ORDER BY ID, Name)

Specifies the sorting direction. The parameter has no effect if sort is not specified. If multiple sorting fields are specified, the number of sorting directions (comma separated) in the sortorder parameter should match that of sort parameter.

Example
If you use *.asp?sort=ID&sortorder=DESC, the records will be sorted by ID in descending order. (ORDER BY ID DESC)
If you use *.asp?sort=ID,Name&sortorder=DESC,DESC, the records will be sorted by ID and then by Name in descending order. (ORDER BY ID DESC, Name DESC)

Specifies the search criteria of a field. The fields to be searched are determined by the "Advanced Search" setting in Field Setup page.

Note that the <fieldname> is encoded for XML tag name, all non-alphanumerical characters, for example, spaces, will by replaced by "_x_<FFFF>_" where <FFFF> is 4 hexadecimal character representing the ASCII value of the character. If the first letter of the field name is a number, it will also be replaced. It is good practice not to use non-alphanumerical characters in a field name.

Note: Parameters should be URL-encoded, for example, the spaces between words become "+" after encoded.

Example
If you use *.asp?x_ID=2, the records with ID = 2 will return. (WHERE ID = 2)
If you use *.asp?x_ID=2&x_Name=abcd, the records will with ID = 2 and Name = 'abcd' will return. (WHERE ID = 2 AND Name = 'abcd')

Specifies the search operator for field. If not specified, the default search operator is "=". Supported search operators are:

Example
If you use *.asp?x_ID=2&z_ID=%3C%3E, the records with ID <> 2 will return. (WHERE ID <> 2)

Specifies the second search criteria for the field. ASP XMLMaker supports up to 2 search operators.

Example
If you use *.asp?x_ID=2&y_ID=9&z_ID=BETWEEN, the records with ID between 2 and 9 will return. (WHERE ID BETWEEN 2 AND 9)

Specifies the search operator for the second search criteria.

Example
If you use *.asp?x_ID=2&z_ID=%3E&y_ID=9&w_ID=%3C, the records with ID > 2 and ID < 9 will return. (WHERE ID > 2 AND ID < 9)

Specifies the condition between the 2 search criteria of the field. Supported condition is "AND" or "OR". Default is "AND".

Example
If you use *.asp?x_ID=2&z_ID=%3C&y_ID=9&w_ID=%3E&v_ID=OR, the records with ID > 2 and ID < 9 will return. (WHERE ID < 2 OR ID > 9)