We're getting a warning in our cloud sql database that Nintex is not escaping parameters when it's querying:
SELECT Job FROM <table> WHERE Site = '{Variable:varDBSite}'
Errors when a site name with a quote is passed:
SELECT Job FROM <table> WHERE Site = 'Rocky's Reward'
On-prem offers the option, however it looks like o365 doesn't? Is there a solution?
Hi,
Unfortunaley I do not have a solution for you but I just wanted to warn you about putting special characters into your site names. You will experience a lot more problems than just this. I have seen basic things like SharePoint online behaving differently between classic and Modern view just because of the apostraphe messing up the URL in Modern view.
@SimonMuntz Sorry I shouldn't have used the term 'Site'. It's not a sharepoint site. Anything that I have control of doesn't have special characters or spaces in them. This is the name of one of our mining sites.
The name 'Rocky's Reward' comes out of the sql database like this with the apostrophe. the 365 workflow sql query needs to be able to escape special characters like it did on-prem. Or we need a work around at the very least.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.