From: Andy Robbo <arobbo61@...>
Date: 2007-06-05T21:37:27+09:00
Subject: Re: Using ADO to connect to an Access database in Ruby

Right , very close to achieving my objective , thanks very much for 
everyones input so far , its really helped me along the learning curve 
with Ruby.

I'm down to one last problem ...

So far , I've connected to my Access database and pulled out a list of 
URLs and there ID's , i've used the URL in the code from Alexa to obtain 
the page rank.

Now all I have to do is somehow parse the XML from the Alexa data back 
into Ruby to insert it back into my database...

This is the XML that i'm trying to parse

Response:

<?xml version='1.0'?>
<aws:UrlInfoResponse 
xmlns:aws='http://alexa.amazonaws.com/doc/2005-10-05/'><aws:Response 
xmlns:aws='http://awis.amazonaws.com/doc/2005-07-11'><aws:OperationRequest><aws:RequestId>asldkfjaslkdjfasldfj</aws:RequestId></aws:OperationRequest><aws:UrlInfoResult><aws:Alexa>
 <aws:TrafficData>
    <aws:DataUrl type='canonical'>rbstardynamic.co.uk/</aws:DataUrl>
    <aws:Rank>5976859</aws:Rank>
  </aws:TrafficData>
</aws:Alexa></aws:UrlInfoResult><aws:ResponseStatus 
xmlns:aws='http://alexa.amazonaws.com/doc/2005-10-05/'><aws:StatusCode>Success</aws:StatusCode></aws:ResponseStatus></aws:Response></aws:UrlInfoResponse>"5"
"essex-electrical.co.uk"

I'm trying to parse the rank # (in this case "5976859")

any clues ?

-- 
Posted via http://www.ruby-forum.com/.