Mercurial > urweb

comparison tests/pquery.ur @ 295:1afa94582275

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Reading ints and floats from SQL
author Adam Chlipala <adamc@hcoop.net>
date Sun, 07 Sep 2008 12:56:46 -0400
parents fdd7a698be01
children 5dc11235129d
comparison
equal deleted inserted replaced
294:df02b09ff1ed 295:1afa94582275
1 table t1 : {A : int, B : string, C : float} 1 table t1 : {A : int, B : string, C : float}
2 2
3 fun lookup (inp : {B : string}) = 3 fun lookup (inp : {B : string}) =
4 s <- query (SELECT t1.B FROM t1 WHERE t1.B = {inp.B}) 4 s <- query (SELECT * FROM t1 WHERE t1.B = {inp.B})
5 (fn fs _ => return fs.T1.B) 5 (fn fs _ => return fs.T1)
6 "Couldn't find it!"; 6 {A = 0, B = "Couldn't find it!", C = 0.0};
7 return <html><body> 7 return <html><body>
8 Result: {cdata s} 8 A: {cdata (show _ s.A)}<br/>
9 B: {cdata (show _ s.B)}<br/>
10 C: {cdata (show _ s.C)}<br/>
9 </body></html> 11 </body></html>
10 12
11 fun main () : transaction page = return <html><body> 13 fun main () : transaction page = return <html><body>
12 <lform> 14 <lform>
13 B: <textbox{#B}/> 15 B: <textbox{#B}/>