SQL SmartObject service

  • 21 January 2009
  • 1 reply
  • 0 views

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

Badge +13

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.

Reply