Skip to Content
avatar image
Former Member

How do I return Return Multiple rows with xMii Runner?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 28, 2010 at 07:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajesh

      That is exactly the syntax I am using

      Regards

      Mark

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

  • avatar image
    Former Member
    Dec 30, 2010 at 06:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded