Mercurial > urweb
comparison tests/pquery.ur @ 296:5dc11235129d
Reading bools from SQL
author | Adam Chlipala <adamc@hcoop.net> |
---|---|
date | Sun, 07 Sep 2008 12:58:33 -0400 |
parents | 1afa94582275 |
children | 59dc042629b9 |
comparison
equal
deleted
inserted
replaced
295:1afa94582275 | 296:5dc11235129d |
---|---|
1 table t1 : {A : int, B : string, C : float} | 1 table t1 : {A : int, B : string, C : float, D : bool} |
2 | 2 |
3 fun lookup (inp : {B : string}) = | 3 fun lookup (inp : {B : string}) = |
4 s <- query (SELECT * FROM t1 WHERE t1.B = {inp.B}) | 4 s <- query (SELECT * FROM t1 WHERE t1.B = {inp.B}) |
5 (fn fs _ => return fs.T1) | 5 (fn fs _ => return fs.T1) |
6 {A = 0, B = "Couldn't find it!", C = 0.0}; | 6 {A = 0, B = "Couldn't find it!", C = 0.0, D = False}; |
7 return <html><body> | 7 return <html><body> |
8 A: {cdata (show _ s.A)}<br/> | 8 A: {cdata (show _ s.A)}<br/> |
9 B: {cdata (show _ s.B)}<br/> | 9 B: {cdata (show _ s.B)}<br/> |
10 C: {cdata (show _ s.C)}<br/> | 10 C: {cdata (show _ s.C)}<br/> |
11 D: {cdata (show _ s.D)}<br/> | |
11 </body></html> | 12 </body></html> |
12 | 13 |
13 fun main () : transaction page = return <html><body> | 14 fun main () : transaction page = return <html><body> |
14 <lform> | 15 <lform> |
15 B: <textbox{#B}/> | 16 B: <textbox{#B}/> |