I am using AEM Designer 8.0 and SQL Server. I have made a form and connected it to the SQL Server. I want to retrieve specific record from the table into the form depending upon the lookup ID entered in the form by the user. I want fetch specific record from the database.
Kindly please help.
On the Exit event of the lookup ID Textfield:
xfa.sourceSet.DataConnection.#command.query.select= concat("SELECT CPTY_SHORTNAME FROM CDH_BANKS_STG WHERE CPTY_CDHID=",cdhid,";")
Copy link to clipboard
This website is for supporting Adobe's CC and TCS products.
AEM is supported at a different website:
You will need to repost your question there.
Be aware that the Community Help forum is for help in using the Community website. Product questions should be posted in the associated product community.
What's a TCS product?
Technical Communication Suite (Framemaker, Robohelp etc)