Just found out that I am going to have build my own Email Confirmation template. I do not knowing anything about XSLT and I am currently at w3 Schools website teaching myself about it, my question is, in the sample templates, it appears that all the data comes from //GetOrderDetailsInfoResults/... Is there documentation or somewhere I can go to find out what fields are available in this uh.. data connection thingy?
Thanks!
Hi Marty,
If you have access to the impresario database, you can pull up the stored procedure [dbo]
[dbo]
.[WP_GET_ORDER_DETAILS]
and that will tell you all the fields that are available. Another good stored procedure to look at is [dbo] .[WP_GET_ORDER_CONF_DATA] Hope this helps. Naomi
.[WP_GET_ORDER_CONF_DATA]
Hope this helps.
Naomi
Thanks Naomi, I think this is what I am looking for.
Marty Jones
Database Administrator
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469 | F 402.345.0222
majones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Thursday, September 03, 2009 4:51 PM To: Martin A. Jones Subject: Re: [Tessitura Web Forum] XSLT
If you have access to the impresario database, you can pull up the stored procedure
and that will tell you all the fields that are available. Another good stored procedure to look at is
From: Marty Jones <bounce-martyjones7649@tessituranetwork.com> Sent: 9/3/2009 4:28:08 PM
You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!