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?

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.
CMWintersAsked:
Who is Participating?
 
Karl Heinz KremerConnect With a Mentor Commented:
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
 
Karl Heinz KremerCommented:
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
 
CMWintersAuthor Commented:
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
 
James MurrellProduct SpecialistCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
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.

All Courses

From novice to tech pro — start learning today.