cancel
Showing results for 
Search instead for 
Did you mean: 
khalidinio
Nintex Newbie

Re: Dynamic SQL select query is not working

How do I need to replace a "non-breaking space" to a normal space? Something like this?

 

 

OLD sql query:

Select ID
From dbo.PersonType
Where Name = '{ItemProperty:VeroorzakerSoort}'

 

New sql query:

Select ID
From dbo.PersonType
Where Name = 'fn-Replace({ItemProperty:VeroorzakerSoort}, , )'

0 Kudos
Reply
Automation Master
Automation Master

Re: Dynamic SQL select query is not working

I'd suggest to do it in a separate action (set variable, build string...), store result to a variable and then reference variable in the SQL.

 

I guess, the way, you depicted it, nintex will misundersatnd meaning of apostrophes and take fn-replace() literally, not as a function.

the other advantage is that you can then write variable into a log to check what exactly is supplied to the SQL.

 

0 Kudos
Reply
khalidinio
Nintex Newbie

Re: Dynamic SQL select query is not working

I created a new workflow variable. I created a new action to set the value of this variable. In this action I do:

 

replace space.PNG

this is logging to the history:

 

replace space logging in history.PNG

The middle space is a normal space. The first and thirs space is the non-break space. How can I replace the non-break space?

0 Kudos
Reply
Automation Master
Automation Master

Re: Dynamic SQL select query is not working

try to insert non breakable space character into formula as ALT+0160

0 Kudos
Reply