Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

XMII Servlet Parameter

Go to solution
Former Member

on ‎2007 Feb 14 4:40 PM

0 Likes
620

Hello,

I have a query which I want to call from a servlet. I have a parameter in the query Equipment = '[Param.1]'

I tried using the following code for the servlet page, but it did not return anyting from the query even though xyz was a valid equipment number.

<html>

<body>

<SERVLET NAME="Illuminator">

<PARAM name="QueryTemplate" value="UserTemplates/TESTSQL">

<PARAM NAME="Content-Type" VALUE="text/xml">

<PARAM NAME="StyleSheet"

VALUE="http://localhost/Illuminator/StyleSheets/IllumRowsetHTML.xsl">

<PARAM name="Param.1" value="xyz">

</SERVLET>

</body>

</html>

Also, how can I call the servlet page from an html webpage and pass the Param.1 in a url. I have a simple webpage which has a text box and a button, on click I want to open the servlet webpage and pass it the value from the text box.

Thanks,

Mahwish

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎2007 Feb 15 5:36 PM
0 Likes

Add in the body of your irpt page the text {Param.1}.

What shows up?

What is the actual URL for the page?

It should be something like http://servername/MyPage.irpt?Param.1=xyz

Show replies
Show replies
Former Member
‎2007 Feb 16 5:39 AM
0 Likes

Hi Mahwish,

I think it is better to create a variable which doesn't have any special character like dot(.)

Thanks,

Rajesh

Answers (2)

Answers (2)

Former Member
‎2007 Feb 16 6:54 PM
0 Likes

Hello Mahwish,

If you still can't get it to work - post the query template's xml code so that I can take a look.

Joe

Show replies
Show replies
Former Member
‎2007 Feb 16 8:00 PM
0 Likes

Thank you all for your help, finnaly got it working with the help of one of our java guys.

Thanks!

Mahwish

Former Member
‎2007 Apr 20 6:50 AM
0 Likes

Perhaps you can help me out since you worked it out with your Java guys. I have a servlet like you that has 3 parameters. I have a form that is calling the servlet page. How do I send the values from the form to the servlet?

Page 1 form has 3 elements:

<p>Customer Number:&nbsp;&nbsp; <input type="text" name="txtCustomer" size="20"></p>

<p>Sales Organization:&nbsp;&nbsp; <input type="text" name="txtSalesOrg" size="20"></p>

<p>Material:&nbsp;&nbsp;&nbsp; <input type="text" name="txtMaterial" size="20"></p>

Page 2 is an .irpt with servlet:

<SERVLET NAME="Illuminator">

<PARAM NAME="QueryTemplate" VALUE="Aware/SalesOrderQuery">

<PARAM NAME="StyleSheet" VALUE="http://localhost/Illuminator/StyleSheets/IllumRowsetTinyHTML.xsl">

<PARAM NAME="Content-Type" VALUE="text/xml">

<PARAM NAME="MappedParamTarget.1" VALUE="Customer=''">

<PARAM NAME="MappedParamTarget.2" VALUE="SalesOrganization=''">

<PARAM NAME="MappedParamTarget.3" VALUE="Material=''">

Thanks for your assistance.

Kim

Former Member
‎2007 Apr 23 4:09 PM
0 Likes

Kim,

Try this:

On the form have an action which calls the irpt page, such as:

<form name = "form1" action="Page1.irpt" method="post">

<input type="text" name = "txtCustomer">

<input type="text" name = "txtSalesOrg">

<input type="text" name = "txtMaterial">

</form>

On the irpt page make sure the txt element name matches your variable name as such, assuming that on your query Param.1 = Customer, Param.2 = Sales Org, Param.3 = Material

<SERVLET NAME="Illuminator">

<PARAM name="QueryTemplate" value="UserTemplates/Query1">

<PARAM NAME="Content-Type" VALUE="text/xml">

<PARAM NAME="StyleSheet" VALUE="http://localhost/Illuminator/StyleSheets/IllumRowsetHTML.xsl">

<PARAM name="Param.1" VALUE=''>

<PARAM name="Param.2" VALUE=''>

<PARAM name="Param.3" VALUE=''>

</SERVLET>

Let me know if this works for you.

Mahwish

Former Member
‎2007 Feb 14 5:27 PM
0 Likes

In your query template if you set Param.1 = xyz on the Parameters tab - do you get results?

Joe

Show replies
Show replies
Former Member
‎2007 Feb 14 6:11 PM
0 Likes

Yes, if I set the first parameter in the query iteself then the results are coming through fine.

Former Member
‎2007 Feb 14 6:20 PM
0 Likes

Does your irpt page return the column headings with no data or just nothing on the page? Are there any errors in the Java Console?

Joe

Former Member
‎2007 Feb 14 6:39 PM
0 Likes

The irpt returns the column headings but with no data. Don't see any errors on the console. Is there any log I can look at on the xmii side to see the values coming through, or put some sort of a trace on the servlet.

Former Member
‎2007 Feb 15 11:33 AM
0 Likes

Hi Mahwish,

I think for this question you can get answer from the other one which yu have a thread.

Thanks,

Rajesh.

Ask a Question