COM-FSM > SIS Documentation > Forms and Reports > Validation > 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  

    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.


    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.


    Powered by MindTouch Core