The 'update user' service from the Authentication Workshop runs a query that has a non-parameterized query to update the user info. If the UserId has an Apostrophe then it fails with the following message:
Incorrect syntax near 'D'. Query:Select PropertyName from EP_Platform_DV.Cantex_EASYCommerceMVC_Base.User_Property_Values where UserId = 'R'D.f'ss' and PropertyName = 'BaseCurrency'
UpdateUser Service and Apostrophe
-
- Posts: 44
- Joined: May 2nd, 2022, 11:53 am
- Contact:
-
- Posts: 567
- Joined: August 26th, 2021, 9:56 am
- Contact:
Re: UpdateUser Service and Apostrophe
Task 10207 is addressing this issue with the service. Once it is completed this post will get updated.
word count: 18