Solved

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
5
185 Views
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.

Thanks.
0
Comment
Question by:CMWinters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
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?
0
 

Author Comment

by:CMWinters
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?
0
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 250 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).
0
 
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.
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
This article focuses on how to remove password security from multiple PDF files by Adobe Acrobat program. Sometimes it is essential to access the stored data items and to print, edit as well as copy content from Portable Document Format files in abs…
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 sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

696 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