Skip to main content
Nintex Community Menu Bar

GetWorkListItems error when sFolio contains quotes

  • September 20, 2007
  • 1 reply
  • 1 view

Forum|alt.badge.img+13

When sFolio contains single quotes    This is 'A', it errors

oWorklistItems = oK2Manager.GetWorkListItems("", "", "Approval", "", sFolio, Nothing, Nothing)

 

An exception of type 'System.Exception' occurred in K2Mng.DLL but was not handled in user code

Additional information: Incorrect syntax near 'A'.
 

1 reply

Forum|alt.badge.img+11
  • Nintex Employee
  • September 20, 2007

Hi Peter,


Thanks, we'll look into it.  I suspect it has got something to do with the SQL Query or Sproc being called in the background. If you replace single quote with 2 x single quote in sFolio, I think it should bring back the right record.


Regards,


Ockert