view tests/ascdesc.ur @ 1564:da11f7b18067

Add an URWEB_PQ_CON environment variable, which overrides the PostgreSQL connection string.
author Austin Seipp <as@hacks.yi.org>
date Fri, 23 Sep 2011 23:11:59 -0500
parents 6f046b4bad24
children
line wrap: on
line source
table t : { A : int }

fun sortEm b =
    queryX1 (SELECT * FROM t ORDER BY t.A {if b then sql_asc else sql_desc})
    (fn r => <xml>{[r.A]}; </xml>)

fun main () : transaction page = return <xml><body>
  <a link={sortEm True}>Ascending</a><br/>
  <a link={sortEm False}>Descending</a>
</body></xml>