Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Calls to SF_Logger within SF_BulkOps do not handle single quotes

The specific case I am working with involves warnings returned when using a table with SF_BulkOps that has additional and/or non-updateable columns although this could technically happen with any log info returned from DBAmp containing a single quote.

example:
"Warning: Column 'LastModifiedById' ignored because it not updateable in the Account object."

I added the following line to SF_BulkOps before the call to SF_Logger to resolve the issue:
SET @LogMessage = REPLACE(@LogMessage,'''','''''')
1 person has
this problem
+1
Reply