[Ur] SQL Count

[David Snider]

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?

_______________________________________________
Ur mailing list
Ur@impredicative.com
http://www.impredicative.com/cgi-bin/mailman/listinfo/ur