For a .pdf, how can I use a selected value in a drop-down list as criteria in an SQL statement to populate the rest of the form?

Posted on 2011-03-22
Medium Priority
Last Modified: 2012-05-11
Basically, I'm wanting to create a .pdf with a dynamic drop-down list - which I've already successfully populated - whose selected value is used in a query that populates the rest of the fields of the .pdf. I'm using Adobe Livecycle. I'm also pretty new to the tool so feel free over-explain.

Question by:CMWinters
  • 2
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 35197331
Take a look at this Adobe article: http://help.adobe.com/en_US/livecycle/9.0/designerHelp/index.htm?content=000553.html

Does this answer your question, or are you aware of this feature, but cannot get it to work?

Author Comment

ID: 35198118
Thanks for the article. This shows me my approach is correct.

What I don't seem to know is the syntax for referencing the selected value of the drop-down list in my query. Basically, I have this:

SELECT storname FROM tblstoremast WHERE stornbr = ?

where the question mark is the selected value of my drop-down list (ddlStoreNumber). I tried ddlStoreNumber.NewText but that didn't work. Am I missing a fundamental here or just how to reference the objects value of my form?
LVL 44

Accepted Solution

Karl Heinz Kremer earned 1000 total points
ID: 35223552
Take a look at this article: http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/
However, in newer versions of Designer, you need to clone the data connection to avoid the security error: http://forums.adobe.com/thread/725742?tstart=-1
(the former link uses FormCalc, the latter one JavaScript).
LVL 31

Expert Comment

by:James Murrell
ID: 36427166
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Can Be Caused By Disabled Services I have encountered a problem viewing PDF files using Adobe Acrobat Reader.  For the longest time, PDFs might launch or might not.  Sometimes they took about 15 minutes to appear after launching them. After som…
Update 21-May-2015: I temporarily removed the source code and the code snippets to make major changes to the program. Regards, Joe A recent question here at Experts Exchange piqued my interest, so I decided to provide a thorough solution and publ…
In this third video of the Xpdf series, we discuss and demonstrate the PDFtoText utility, which converts PDF files into plain text files. Download and install the software.: You may have already downloaded and installed the Xpdf tools while watching…
In this video, we show how to perform Bates Numbering/Stamping of PDF documents using Power PDF Advanced, the newest product from the Document Imaging division of Nuance Communications. There are two editions of Power PDF — Standard and Advanced. Th…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question