Mercurial > urweb
view demo/view.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 | c7b9a33c26c8 |
children |
line wrap: on
line source
table t : { A : int } view v = SELECT t.A AS A FROM t WHERE t.A > 7 fun list [u] (_ : fieldsOf u [A = int]) (title : string) (x : u) : transaction xbody = xml <- queryX (SELECT * FROM x) (fn r : {X : {A : int}} => <xml><li>{[r.X.A]}</li></xml>); return <xml> <h2>{[title]}</h2> <ul>{xml}</ul> </xml> fun main () = listT <- list "T" t; listV <- list "V" v; return <xml><body> {listT} {listV} <br/> <form>Insert: <textbox{#A}/> <submit action={ins}/></form> </body></xml> and ins r = dml (INSERT INTO t (A) VALUES ({[readError r.A]})); main ()