Skip to main content
Nintex Community Menu Bar

SQL SmartObject service

  • January 21, 2009
  • 1 reply
  • 7 views

Forum|alt.badge.img+3
Hi,

I have an InfoPath form were the user enter some comments (multiline box) before submitting to the process. I then use the comments field in a create SmartObject to insert into an SQL database.

When the user enters a single quote (') in his comments, the SmartObject fails with the following message

Incorrect syntax near ’s’. Unclosed quotation mark after the character string ’, 19, NULL) 

Did anyone had this issue? 

Dominic

1 reply

Forum|alt.badge.img+13
  • Rookie
  • January 22, 2009

I am assuming you are doing a regular Insert or Update SQL.

Try using a stored procedure with parameter binding, it should resolve the single/double quote problem.