Mercurial > urweb
annotate tests/lower.ur @ 1682:ac141fbb313a
'ORDER BY RANDOM' (based on a patch from Ron de Bruijn)
| author | Adam Chlipala <adam@chlipala.net> |
|---|---|
| date | Thu, 02 Feb 2012 11:40:10 -0500 |
| parents | 2b312f6d4007 |
| children |
| rev | line source |
|---|---|
| adam@1636 | 1 table lower : { A : string } |
| adam@1636 | 2 |
| adam@1636 | 3 fun main () : transaction page = |
| adam@1636 | 4 all <- queryX1 (SELECT * |
| adam@1636 | 5 FROM lower |
| adam@1636 | 6 WHERE lower(lower.A) LIKE '%foo') |
| adam@1636 | 7 (fn r => <xml>{[r.A]}<br/></xml>); |
| adam@1636 | 8 return <xml><body> |
| adam@1636 | 9 {all} |
| adam@1636 | 10 </body></xml> |