Mercurial > urweb

view tests/sqliteTime.ur @ 1466:e2d7bd41f527

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remember to remove explicit table projections in SQLite UPDATE SET values
author Adam Chlipala <adam@chlipala.net>
date Mon, 30 May 2011 07:48:08 -0400
parents 703c2c94afd5
children
line wrap: on
line source
table dates : { Date : time }

fun aform () =
    let
        val a : time = readError "01/02/03 04:06:07"
    in
        dml(INSERT INTO dates (Date) VALUES ({[a]}));
        ds <- queryX (SELECT * FROM dates)
                     (fn r => <xml>{[r.Dates.Date]}<br/></xml>);
        return <xml><body>{ds}</body></xml>
    end

fun main () =
  return <xml><body><form><submit action={aform}/></form></body></xml>