Download Here

•
.GE e.g. ID.GE=123 → ID >= 123
adds the field to the WHERE clause using a greater than or equal operator.
•
.GEN e.g. ID.GEN=123 → ID >= 123
same as .GE but coerces the value to a number using asNumber.
•
.GES e.g. ID.GES=123 → ID >= '123'
same as .GE but coerces the value to a string using asString and encloses the field in
single quotes.
•
.GT e.g. ID.GT=123 → ID > 123
adds the field to the WHERE clause using a greater than operator.
•
.GTN e.g. ID.GTN=123 → ID > 123
same as .GT but coerces the value to a number using asNumber.
•
.GTS e.g. ID.GTS=123 → ID > '123'
same as .GT but coerces the value to a string using asString and encloses the field in
single quotes.
•
.LE e.g. ID.LE=123 → ID <= 123
adds the field to the WHERE clause using a less than or equal operator.
•
.LEN e.g. ID.LEN=123 → ID <= 123
same as .LE but coerces the value to a number using asNumber.
•
.LES e.g. ID.LES=123 → ID <= '123'
same as .LE but coerces the value to a string using asString and encloses the field in single
quotes.
•
.LIKE e.g. name.LIKE=George → name LIKE 'George'
adds the field to the WHERE clause with a LIKE operator. This is very similar to using
‘=‘. However, the value of LIKE is when the user is allowed to type in the % character as
part of the input: thus positioning the ‘wildcard’ somewhere in the input text rather than
just at the beginning and/or the end of the string. Even if the wildcard character is to be at
the beginning or the end, the user who is entering the text has control over where the %
character is located and not the developer of the Web page.
•
.%LIKE% e.g. name.%LIKE%=George → name LIKE '%George%'
adds the field to the WHERE clause with a LIKE operator and includes wild carding at
both ends of the string.
•
.%LIKE e.g. name.%LIKE=George → name LIKE '%George'
adds the field to the WHERE clause with a LIKE operator and includes wild carding at the
beginning of the string.
•
.LIKE% e.g. name.LIKE%=George → name LIKE 'George%'
adds the field to the WHERE clause with a LIKE operator and includes wild carding at the
end of the string.
•
.LT e.g. ID.LT=123 → ID < 123
adds the field to the WHERE clause using a less than operator.
•
.LTN e.g. ID.LTN=123 → ID < 123
same as .LT but coerces the value to a number using asNumber.
WebBase User’s Guide
259