in message <[email hidden]>, Simon
Brooke (') said:I set out this morning with the idea I was going to do a bit of XSLT
to convert the Cycling News results pages into SQL, but it turned out
the interesting data was all in a pre block. So instead I've done a
bit of work on a PERL script todo the job.
As an addendum, you can suck all the results (except prologues) for last
years and this years grand tours with:
for year in 05 06
do
for tour in giro tour vuelta
do
for stage in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
do
wget -O - \
http://www.cyclingnews.com/road/20$year/$tour$year/?id=results/$tour$year$stage |
perl results.pl | psql cyclist;
done
done
done
AI .sig generator frighteningly accurate, as usual.
--
[email hidden] (Simon Brooke) http://www.jasmine.org.uk/~simon/
[ Disclaimer:  This is a work displacement exercise.  Please feel free ]
[ to reply either on or off group.  Expect lengthy replies until the ]
[ deadline has passed.  Thank-you for your cooperation. ]