result set in sql query template

[Former Member]

where the resultset is stored in the Sql query template.

[Former Member]

I called a BLS transaction in the xacute query which in turn calls sql query template.

I am not able to pass parameter to xacute query template from html.

I am not sure whether the problem is with html or with the xacute query itself.so how to check whether the xacute query is working fine without html.

[prasanna_vittal]

Hi,

In the xacute query, under the "transaction details" tab, you can pass values to the uinput parameters. Drag the input parameter to "Mapped Param. Target" and give a value under "param". And click on "test" button at the top to see if it works.

[Former Member]

Hi Prasanna

The problem is with html. It is working now.

Thanks

Latha

[jcgood25]

When you use the term 'resultset', I assume you mean the dataset being returned by the query itself. This dataset is only an in-memory resultset that is streamed to the requesting object such as an iGrid, iChart, SQLQuery action block, html screen results, etc. MII does not store the data query results in order to visualize them, it is a streaming process direct from the underlying database to the request object.

Regards,

Jeremy

[Former Member]

Thanks jeremy

latha