Re: FN-FORUM: Okay im stuck

date posted 4th May 2007 19:44

Hi,


> Need some help, im almost there but can't find the right combination of code
>
> Im trying to read the following XML
> http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml using ASP and output
> a rate based on a currency.
>
> Here is the code I have
>
> Dim URL, count, objXML, i, counter
> URL = "http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml"
> Set objXML = Server.CreateObject("Microsoft.XMLDOM")
> Set objLst = Server.CreateObject("Microsoft.XMLDOM")
> objXML.setProperty "ServerHTTPRequest", True
> objXML.async = False
> objXML.Load(URL)
> Set objLst = [EMAIL REMOVED]
> noOfHeadlines = objLst.length
> For i = 0 To (noOfHeadlines - 1)
> Response.Write(objLst.item(i).text & "")
> Next
> Set objLst = nothing
> Set objXML = nothing
> %>
>
> That shows all the currencies but I need to get the rate based on one of the
> currencies.
>
> Please help.
>

I don't know visual basic, but I'd be surprised if it's not one of:

objLst.item(i).attribute( 'rate' )

or

objLst.item(i).attributes( 'rate' )

or

objLst.item(i).getAttribute( 'rate' )

Graham


> Regards
> Sam Morgan
> WiredEyes Media / ServWise Advanced Hosting
> tel (Uk): +44 (0)20 7100 2178
> tel (Italy): +39 070 773 6543
> web : www.wiredeyes.com / www.servwise.com
> ----
> umop ap!sdn w,! aw dlaH
>
>
>
>
>