5.35.57 bug in Membership provinder
Posted: Tue 15 Dec 2009 09:22
Hi,
The membership query:
filter is username, and the sql is (from monitor)
Please fix it!
The membership query:
Code: Select all
MembershipUserCollection users = prv.FindUsersByName(filter, 0, int.MaxValue, out count);
Code: Select all
SELECT username, password, u.userid, email, passwordquestion, passwordanswer, comments, isapproved, islockedout, creationdate, lastlogindate, lastactivitydate, lastpasswordchangeddate, lastlockoutdate FROM aspnet_membership m, aspnet_users u WHERE u.userid = m.userid AND LOWER(u.applicationname) = :applicationname order by username AND LOWER(username) LIKE :username