COM-FSM
Register

Page statistics

3649 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