Thu, 24 Sep 2026
Login

SQL and environment variable with apostrophe

Confluence User - 08 Aug, 2020

when using JDBC action in datalist  and try to update a row using environment variable lastname

the statement fails because the lastname has apostrophe.


update ...

set modifiedByName = '#currentUser.firstName#' + '  ' + '#currenUser.lastName#'

where ...

datalists;forms

4

Confluence User •
08 Aug, 2020 •
confluenceUser •
•
confluenceUser •

hello guys


Confluence User •
09 Aug, 2020 •
confluenceUser •
•
confluenceUser •

Hi, you can try to escape the hash variable value Hash Variable#EscapingtheResultantHashVariable

Confluence User •
11 Aug, 2020 •
confluenceUser •
•
confluenceUser •

'#currenUser.lastName?sql#' worked.


Thanks!

Confluence User •
10 Dec, 2020 •
confluenceUser •
•
confluenceUser •

https://cellinfo.in/true-love-story-in-hindi/ 
Most Helpful. Thanks!

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print