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