Escape single quote

dflkid

• September 03, 2016 00:00

• Answered

Follow

I'm trying to pass in a SQL statement from a DataGenerator to a DBInputTable component via the Query URL (port:$0.field1:discrete). The problem is that the DBInputTable seems to not be able to process a single quote in my query (SQL snippet below).

CONCAT(associates.firstname, ' ', associates.lastname)

Is there a way to escape the single quote? I've tried several things but nothing seems to work.

• 

  Lukas Cholasta

  • September 07, 2016 13:58

  0

  Comment actions Permalink

  Hi,
  
  I just tested a similar usage with no issues. In order to resolve your issue please provide me with the following.
  
  

  1. Version of your Designer.
  2. Version of your MS-SQL database.
  3. Your graph file without any sensitive information.
  4. Your console output when the error occurs. Just copy-paste it, please.
  

  
  Thank you,
• 

  dflkid

  • September 08, 2016 22:24

  0

  Comment actions Permalink

  I sent the pertinent details to Jay Benedetti and Kevin Scott, as I was on a call with them regarding other matters.

Please sign in to leave a comment.