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
184 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
The Adobe PDF proprietary file format is recognized as secure and formulated. But these PDF files are also prone to corruption and any external threat like virus attacks, improper storage can hit PDF file integrity.This type of damages can make cruc…
In this second video of the Xpdf series, we discuss and demonstrate the PDFimages utility, which, in a single command, is able to extract all the images from a PDF file and save each one in a separate image file (PBM, PPM, or JPG). Download and inst…
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…
Suggested Courses

739 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