Question & Answer > View Question

Database tool issue(using Joget v6)

Confluence User - 07 Jul, 2021

Hi Experts,

I am facing error using database update tool in workflow because sometimes query contains string value with apostrophe then error comes.Can anyone tell me how to handle this type of query in database tool.

Thanks in advance

database;tools;workflow;plugins

1

Confluence User •

08 Jul, 2021 •

confluenceUser •

•

confluenceUser •

Hi, if you are using Hash Variables then you can escape the values for SQL like in Hash Variable#EscapingtheResultantHashVariable.

1

CSV | Excel | XML | PDF

Your answer

Print

Database tool issue(using Joget v6)

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

Database tool issue(using Joget v6).builder-style-a7b5d26b-3727-4909-a20b-d5d46a748b31{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

1.builder-style-2d8062c8-6d2c-48c3-be1b-2f681637e110{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-33ecabf7-84e8-4c47-ba6f-fa6c0bfd05fe{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

Database tool issue(using Joget v6)

1

Your answer