Anyone tried using XMP with multiple recordsets from a single stored procedure?

I was just wondering if it can be done? How would one refer to the fields?

Gus

You cannot do it at this time. But there are other ways to accomplish this. Can you send me an example of what you are trying to do?

dgentry@infotrx.com

Hi Derek

thanks, in the end I managed to pursuade the client to give me a separate SP for each recordset.

thanks
Gus

Hi Derek,

Even though Angus found a solution perhaps you'd be willing to help me out with a very similar problem.

I currently have a classic asp application (basically a big form) that collects information from our accounting system via 4 seperate queries (these likely could be converted to stored procedures) then includes the result sets from the queries in the form as form fields.

I would definitely like to use XMP to port this application into DNN and our intranet, though I am stuck at including one than one queries recordset in a selectcommand.

How would I be able to include an additional set of 3 query results or the values from a multiple recordset stored procedure?

Is this possible using XMP?

Any light you can shine on this would be much appreciated.

Thanks for your help..

Mark

Of course. Always willing to help.

Yes XMP is a very powerful tool. You can create a master template with 4 seperate templates in it. Each one showing a different recordset. I cannot imagine (although not improbable) that you are trying to combine the 4 recordsets into one list template.

Maybe if you share with me a little info on the application itself I can help you design it.

Derek

I have one template, a searchsort that queries an external database of clients and uses a itemtemplate to return a list of clients that have met the search criteria, a hyperlink is displayed using a url parameter populated with the client number from the itemtemplate record.

The hyperlink is a redirect to an addform which uses the url parameter in a selectcommand to query an external databasetable to gather address information for the client number passed to it as the url parameter. It then populates addform fields with this additional address information.

All this is working beautifully so far...

Now..In addition to client address information I need to populate approximately 15 additional form fields based upon three queries from our accounting system. These queries are driven by the same parameter used in pulling in the client address information.

This is where I'm stuck. I need a way to return the results from three other queries (each query only returns one row.) and prepopulate additional fields in the addform.

hope this makes sense.. if not i can send screen shots.

Thanks..

Mark