UpdateUser Service and Apostrophe

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
AkshayKhanolkar
Posts: 44
Joined: May 2nd, 2022, 11:53 am
Contact:

UpdateUser Service and Apostrophe

Unread post by AkshayKhanolkar »

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'
image.png
word count: 61

Tags:
JustinVanRegenmorter
Posts: 575
Joined: August 26th, 2021, 9:56 am
Contact:

Re: UpdateUser Service and Apostrophe

Unread post by JustinVanRegenmorter »

Task 10207 is addressing this issue with the service. Once it is completed this post will get updated.
word count: 18
Post Reply