Hello,
Has anyone had success combining data results from a Local Procedure with the regular order info that is returned by the email confirmations? For instance, we want to include web content information from the Content tab (that is pulled by a Local Procedure) with order information returned by the GetOrderDetails that the order confirmation, and combine it all into one dataset before the XSL transformation. This C# is a bit over my head, so I'm hoping someone who has successfully combined these two things can offer some guidance.
Thanks!
Hello Brian,
Yes I have done this before, I am brining data from a custom call appending it to the OrderData result set. The appeneded data is available in the transform. Here is a link to an older post I submitted on this topic: http://www.tessituranetwork.com/Community/forums/p/1470/5085.aspx The zip file I submitted contains the template with code where I am doing this.
Jon
Hi Jon,
That's great; thanks! That looks like exactly what we're looking for. One question, though. I'm getting a compilation error; is that code built just for integers? The information we're looking to pull would be an alphanumeric string.
Thanks,
Brian