Hi Friends,
We are wanting to setup an RSS feed that sends out a notification every time an event goes on Public onsale.
Has anyone written a stored procedure that does this?
Thanks!
Chris SzalajTPAC
We have something like this. I will put it together and send it over.
Here is a query that gives you the event name, and production season number for performances that have either have a status of on sale or have the on sale indicator checked off. What we do is something like this but we also only show 60 days worth of upcoming events. Also we cache the RSS feed for a day. This is to help with cutting down the frequency the feed has to make a sql server call to for generating the feed. If you would like I can make our .NET code available for you.
select distinct ps.prod_season_no,i.description from t_prod_season ps Join t_perf p on p.prod_season_no = ps.prod_season_no join t_inventory i on i.inv_no =ps.prod_season_no where avail_sale_ind='Y' or perf_status=1
Jon:
1. Love your avatar.
2. Thanks for the code. I really appreciate it. I may hit you up for the .net source in a few weeks. I really appreciate it. Chris