Thu, 24 Sep 2026
Login

SQL can't work in section

Confluence User - 26 May, 2020

I configured "Load Binder" in Section as JDBC to load specific value as below, but I found after I configured, the Why  does "and c_BayNo = 'form.B04_Application.BayNo'" don't work in SQL ?

forms;section

3

Confluence User •
26 May, 2020 •
confluenceUser •
•
confluenceUser •

Just curious why is there a question mark at the end of your form hash #form....BayNo?#.

Btw what is the error description in the ".\apache-tomcat-8.5.41\logs\joget.log"?

Did you test the SQL in an SQL manager utility, after replacing the #username...# with the actual temp value?

Confluence User •
26 May, 2020 •
confluenceUser •
•
confluenceUser •

Sorry, I use #form....BayNo# instead, but it still doesn't work.  And it's no any related log description in log file.

Confluence User •
03 Jun, 2020 •
confluenceUser •
•
confluenceUser •

There should be error printed out in joget log. Check it out and share here.

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