Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-08-19
3
Medium Priority
?
411 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
[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
3 Comments
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Getting information about Fonts being used in a PDF file A colleague of mine recently faced an issue related to the PDF file format. The PDFs were containing mission critical client information, they were successfully mailed but there was a sm…
Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

715 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