Mercurial > urweb
view tests/rpcN.ur @ 1168:69f1d39d3f2d
Use COALESCE to hide NULL results of aggregate functions; fix bug with improper ordering of query result columns
author | Adam Chlipala <adamc@hcoop.net> |
---|---|
date | Thu, 25 Feb 2010 14:55:35 -0500 |
parents | 5891f47d7cff |
children |
line wrap: on
line source
table t : { A : int } fun main () : transaction page = let fun count a = r <- oneRow (SELECT COUNT( * ) AS N FROM t WHERE t.A = {[a]}); return r.N in s <- source 0; return <xml><body> <button value="Get It On!" onclick={n <- count 3; set s n}/><br/> <br/> Current: <dyn signal={n <- signal s; return <xml>{[n]}</xml>}/> </body></xml> end