Embedding single quotes in SQL select statement

Stacy Lee-Curbean

Created a custom module that allows a user to enter a sql statement in the admin index. The sql statement is stored in the kini table. When I retrieve the statement from the kini table, LL automatically escapes the single quotes with a backslash. How should single quotes be embedded to avoid this issue? Or how do I remove the backslash escape characters? I have tried the Str.ReplaceAll but this doesnot work. Here is the sql statement:selecttitle as "Name",textattribute5 as "Routing Number",textattribute1 as "Supplier Name",textattribute2 as "Invoice Number",dateattribute1 as "Invoice Date",numberattribute1 as "Invoice Amount",priority as "Priority"from wftask where state = 'ASSIGNED'

Philip Forshaw

Message from Philip Forshaw <philip.forshaw@res-ltd.com> via eLink

eLink

Stacey, are you experiencing problems withthe SQL once retrieved? I had a similar concern but found OScript knew what wasgoing on and did not display or use the backslashes.

 

Phil

 

From:eLink Discussion: Livelink Builder Discussion[mailto:componentbuilder@elinkkc.opentext.com]
Sent: 21 July 2009 22:22
To: eLink Recipient
Subject: Embedding single quotesin SQL select statement

 

Embedding single quotes in SQL select statement

Posted by staceyl (Lee-Curbean, Stacey) on 2009/07/21 17:18

 

Created a custom module that allows a user to enter a sql statement in the admin index. The sql statement is stored in the kini table. When I retrieve the statement from the kini table, LL automatically escapes the single quotes with a backslash. How should single quotes be embedded to avoid this issue? Or how do I remove the backslash escape characters? I have tried the Str.ReplaceAll but this doesnot work. Here is the sql statement: select title as "Name", textattribute5 as "Routing Number", textattribute1 as "Supplier Name", textattribute2 as "Invoice Number", dateattribute1 as "Invoice Date", numberattribute1 as "Invoice Amount", priority as "Priority" from wftask where state = 'ASSIGNED'

CONFIDENTIALITY NOTICE: This e-mail, including any attachments, contains information that may be confidential, and is protected by copyright. It is directed to the intended recipient(s) only. If you have received this e-mail in error please e-mail the sender by replying to this message, and then delete the e-mail. Unauthorised disclosure, publication, copying or use of this e-mail is prohibited. Any communication of a personal nature in this e-mail is not made by or on behalf of any RES group company. E-mails sent or received may be monitored to ensure compliance with the law, regulation and/or our policies.