How do I return Return Multiple rows with xMii Runner?

[Former Member]

Hi

I have built a Query Template that calls a MS SQL Server stored procedure. This procedure returns multiple rows of data.

I have wrapped this Query in a Transaction that has an XML output parameter to reurn the query information.

If I use an Xacute Query to run the Transaction everything works and I get the multiple rows returned as XML. However, if I use the XMII Runner facility in the browser, only the first row is returned.

Can anyone please tell me how do I get the XMII Runner to give me all of the rows generated by the Transaction?

Thanks in advance

Mark

[Former Member · Accepted solution]

Hi,

Find the below syntax for MII Runner.

http://<servername>:<port>/XMII/Runner?Transaction=<path of transaction/transaction name>&<input parameter name=value>&<OutputParameter=parameter name>

Aforesaid syntax works fine for me. Let me know if you face any issues.

Thanks

Rajesh S

[Former Member · Accepted solution]

Hi Rajesh

That is exactly the syntax I am using

Regards

Mark

Edited by: MarkIo on Dec 28, 2010 9:06 AM

[Former Member]

I completely re-built the query and transaction from scratch and the problem went away. Both the old and new components look identical but the new one returns multiple rows.

I quess I'll chalk this one up the experience

Cheers

Mark