Solved

How to use Textfield instead of drop down for input to populate the pdf using livecylce es2

Posted on 2010-08-19
3
406 Views
Last Modified: 2012-05-10
Hi There


I was finally able to populate the field by hard coding the where to clause

 

form1.#subform[0].Button1::click - (FormCalc, client)
$sourceSet.DataConnection.#command.query.commandType= "text"
$sourceSet.DataConnection.#command.query.select.nodes.item(0).value= Concat("Select * from performview Where Empno = ", 10 ,"")
$sourceSet.DataConnection.open()

 
I want to use a textfield where the user of the form will enter the empno which will be applied to the query. I have only seen example for drop down list intialize, I don't want to use drop down list as it take a long time when we open the pdf as our table that drop down list uses is big and it times out.
So i want to use the input from a textfield where user's enter the number for Empno field and I use that to do the query how would I do this?

 
so I want to pass $sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat("Select * from performview Where Empno = ", This should be from the textfield selectfield ,"")

 
So how do I initialze a textfield to do this?
0
Comment
Question by:Sivasan
  • 2
3 Comments
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 500 total points
ID: 33484149
You can access the value of a text field with the following FormCalc construct:

TextField1.rawValue

If you want to assign this value to another text field, you would use something like this:

TextField2.rawValue = TextField1.rawValue

In your case, you would just something like
$sourceSet.DataConnection.#command.query.select.nodes.item(0).value= Concat("Select * from performview Where Empno = ", TextField1.rawValue)
0
 

Author Comment

by:Sivasan
ID: 33505000
Hi Thanks for the response.
This is the one that worked had to have ' ",   ," ' ".
$sourceSet.DataConnection.#command.query.select.nodes.item(0).value= Concat("Select * from performview Where Empno = ' ", TextField1.rawValue, " ' ")
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 33505146
Makes sense - the strings needs to be quoted. Sorry about that.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Suggested Solutions

Title # Comments Views Activity
reduce size of all found pdf in adobe pro 1 44
Adobe Acrobat Pro DC & Document Cloud 2 138
what font behind pdf 32 149
How can I convert HTML files to .pdf files? 9 66
Acrobat’s JavaScript is a great tool to extend the application, or to automate recurring tasks. There are several ways a JavaScript can be added to the application or a document (e.g. folder level scripts, validation scripts, event handling scripts,…
PaperPort is a popular document imaging/management product from Nuance Communications (http://www.nuance.com/). It is in widespread use by both individuals (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) and businesses (http:/…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

856 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