Escape single quote

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

dflkid
Posts: 26
Joined: Mon Feb 23, 2015 8:57 am

Escape single quote

Postby dflkid » Sat Sep 03, 2016 5:49 pm

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).

Code: Select all

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


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

cholastal
Posts: 135
Joined: Tue Sep 01, 2015 1:22 pm

Re: Escape single quote

Postby cholastal » Wed Sep 07, 2016 2:58 pm

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,

---
Lukas Cholasta
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com

dflkid
Posts: 26
Joined: Mon Feb 23, 2015 8:57 am

Re: Escape single quote

Postby dflkid » Thu Sep 08, 2016 11:24 pm

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


cron