Skip to main content
Nintex Community Menu Bar

SQL lookup concatenating values in return field

  • May 30, 2019
  • 1 reply
  • 5 views
Forum|alt.badge.img+2

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

    1 reply

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • June 28, 2019
    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?
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement