COM-FSM
Register

Page statistics

3221 view(s) 2 edit(s) 1740 characters(s)
Was this page helpful?
Yes No
Page Notifications Off
COM-FSM > SIS Documentation > Forms and Reports > Validation > Comparison

Comparison

Page last modified 13:58, 22 Feb 2009 by kgirrard
Table of contents
No headers

Comparison operators

Summary Comparisons used to express relationships (e.g. greater than, equal to) between values.
Maintainer Information Technology
Source Information Technology
Affects Various forms and reports that evaluate information based on conditional relationships
Affected By  
Values

SQL is a printf-style string with placeholders (%s) for the left- and right-hand sides of the comparison, or multiple values in the case of more complex expressions.

Javascript is a regex replacement string using positional parameters ($1, $2, etc.). The left-hand side is expressed as $1.
Requirements  
Operation

The order of the values supplied for the SQL string is the same for all expressions; the left-hand side is always the database value being tested, the right-hand side is what the database value is being compared with.

For expressions that evaluate a range (e.g. BETWEEN) a lower and upper bound are expected.

Sets of values can also be used, and are generally constructed from a comma-separated list of values, but may also be an SQL sub-query.

 

Attach file

Files0

 

Comments0

You must login to post a comment.
Powered by MindTouch Core