Mercurial > urweb
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>