on 12-28-2010 6:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.