Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
czeller
Starting Member
10 Posts |
 Posted - 2004-02-24 : 15:14:41
|
we're getting ready to do an online bracket for the ncaa men's tourney and one of the things we're trying to have is a live scores page. our data will come from the associated press (unless i find a simpler/better source) and they provide the data in the form of nntp posts that return xml attachments. here's my current process as best i understand it (setup is sql2K, win2K, IIS 5, ASP):1-use AspNNTP (http://www.serverobjects.com/comp/AspNNTP.htm) to pull down the nntp posts that hold the data2-once i've done some work w/ the AspNNTP to get the xml attachment from each post, i will have a raw xml file which i'm thinking i will then put into a sql server table (not sure on the design of that table just yet)(steps 1 and 2 will run every minute or so through a script)3-then from my "scores" page, i will pull my data from my table and parse the XML into whatever format i wanti guess that sounds simple enough, but this is all VERY new to me, so i'm just hoping someone else out there may have done something similar and can help me w/ the necessary steps involved. does what i've outlined above seem like the right way to do it? i should note that the nntp feed provides each "updated" game score as a separate post (xml file). so let's say there's 16 games going on - that will mean i will be getting updated posts constantly in separate files for EACH game - i'm not real sure what to do w/ that??any ideas? just seems overly complicated for what i need to do - which is just get some live scores! i guess i thought i'd be hitting a single xml file somewhere out there that had all the data in one place and then parse it through on my end - lolthanks for your help! let me know if i've been as clear as mud  |
|
|
czeller
Starting Member
10 Posts |
Posted - 2004-02-24 : 16:49:01
|
| bah, the more i think about it, the more insane it gets. that's way too much effort for the end result. i'm just going to look for another source that provides the data in raw xml format - thanks! |
 |
|
|
|
|
|
NNTP, XML and SQL