Hi there,
I am using an updategram to update multiple records from a web page.
XML data is returned to the browser and then rendered by binding a table to
the XML using datasrc="#XMLdata"
When clicking the update button I dynamically build the updategram string by
looping through the records using the RecordSet object. I then set the
"template" field on the form to the value of the string. So the updategram
might look like this:
<ROOT xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
<updg:sync >
<updg:before>
<tblCustomerForecast CustomerForecastID="96" />
</updg:before>
<updg:after>
<tblCustomerForecast ForecastID="18" CustomerProductLineID="26" />
</updg:after>
<updg:before>
<tblCustomerForecast CustomerForecastID="97" />
</updg:before>
<updg:after>
<tblCustomerForecast ForecastID="18" CustomerProductLineID="27" />
</updg:after>
</updg:sync>
</ROOT>
I then submit this template to SQL Server and specify an XSL template called
jumpback.xsl (this does a window.history.back to return the user to the
submitting
page so that the updated results can viewed immediately).
How can I perform the same sort of update but calling a stored procedure for
each record that I want to update and how do I get the return value from a
stored procedure that I call using this method.
Thanks
Reuben