view tests/lower.ur @ 1866:9fc086e3c95a

Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite.
author Sergey Mironov <grrwlf@gmail.com>
date Fri, 13 Sep 2013 10:09:15 -0400
parents 2b312f6d4007
children
line wrap: on
line source
table lower : { A : string }

fun main () : transaction page =
    all <- queryX1 (SELECT *
                    FROM lower
                    WHERE lower(lower.A) LIKE '%foo')
                   (fn r => <xml>{[r.A]}<br/></xml>);
    return <xml><body>
      {all}
    </body></xml>