[Ur] SQL Count

David Snider david at davidsnider.net
Tue Mar 2 20:40:04 EST 2010


fun isValid r =
     oneRow (SELECT COUNT(*) FROM users
                 WHERE Username = {[r.Username]}
                   AND Password = {[r.Password]}) = 1

It seems to be treating COUNT(*) as a comment. How do I get a record count?



More information about the Ur mailing list