U4-3211 - User.GetAllByEmail has malformatted SQL in !useExactMatch branch

Created by Randy McCluer 22 Oct 2013, 02:14:37 Updated by Shannon Deminick 21 Jun 2017, 07:58:15

Looks like maybe there was a string.format call in some older version, perhaps.

dr = SqlHelper.ExecuteReader("Select id from umbracoUser where userEmail LIKE {0} @email", SqlHelper.CreateParameter("@email", String.Format("%{0}%", email)));

Not sure if this code will remain after new User API is available, so may be irrelevant.

Comments

Sebastiaan Janssen 22 Oct 2013, 06:34:12

What's the problem and how does it manifest itself?


Randy McCluer 22 Oct 2013, 17:41:44

If you call GetAllByEmail with useExactMatch==false, you get a sql exception due to syntax error.


Shannon Deminick 21 Jun 2017, 07:58:15

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/


Priority: Normal

Type: Bug

State: Closed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.2.0

Due in version:

Sprint:

Story Points:

Cycle: