fuller
Nintex Newbie

SQL lookup concatenating values in return field

A SQL lookup based on a previously selected value (also a SQL lookup) within a form is returning the correct value, but somehow concatenating itself with ;# inbetween. For example, where I would expected 10300 the value being returned is 10300;#10300. The source data has been verified and looks clean.

 

I can clean this up with a function, but that just adds another layer. 

 

Thanks

0 Kudos
Reply
1 Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: SQL lookup concatenating values in return field

Hi,

When you say SQL Lookup I assume you are using the SQL Request control.
I looked into this issue but was not sure how you were going about filtering one SQL Request control off of another.
Are you able to provide more datils of your setup so that I can try replicate the issue and look for a resultion?
0 Kudos
Reply