Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fetching an XML file by using a aspx page
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Divers
Thread ID:
01111310
Message ID:
01111311
Vues:
11
Solved it...
I should have Googled first.
This is what did the trick:
	CREATE CURSOR myWebPage (content m)  
	url="http://www.whereever.intra/datamanagement/tblMSDSXML.aspx"  
	objHTTP = CreateObject("MSXML2.XMLHTTP")  
	objHTTP.Open("GET", url,.f.)  
	objHTTP.Send()  
	Insert into myWebPage (content) VALUES (objHTTP.ResponseText)  
	MODIFY MEMO myWebPage.content 
>I want to fetch the result of a webpage (XML) and process it in VFP. I have therefor done the following:
>
>
>oIE = CREATEOBJECT("InternetExplorer.Application")
>oIE.Navigate("http://www.whereever.intra/datamanagement/tblMSDSXML.aspx")
>
>INKEY(1)
>nStartSeconds = SECONDS()
>DO WHILE oIE.Document.ReadyState <> "complete" AND (SECONDS()-nStartSeconds < 30)
>ENDDO
>
>IF oIE.Document.ReadyState <> "complete"
>	MESSAGEBOX("Page was not retrieved")
>	oie.Visible = .T.
>	RETURN .F.
>ELSE
>	SET STEP ON 	
>	oie.Visible = .T.
>	* and now what? How can I read what the browser is now showing
>ENDIF
>
>
>This routine works nicely but how can I now retrieve what the browser is showing me? I'm interested in the content of the browser as it is shown now.
>
>Thanks in advance,
>
>Ron Brahma
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform