[Ur] SQL Question

[Adam Chlipala]

On 10/03/2014 02:21 PM, Burton Samograd wrote:
> Are you limited to one query per transaction?

No.  Your code example below seems to be missing semicolons at line ends.

> This type of code causes compiler errors where a single query doesn't:
>
> fun page () : transaction xbody =
>
> data <- (SELECT * FROM table ...) (fn row => ...)
> data2 <- (SELECT * FROM table2 ...) (fn row => ...)
>
> (* Generate part of the page with data *)
> {header data}
>
> (* Generate another section with data2 *)
> {footer data2}