GetWorkListItems error when sFolio contains quotes

  • 20 September 2007
  • 1 reply
  • 0 views

Badge +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

Badge +11

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

Reply