Problem in getting response from remote server

[vtpvp82]

I am having problem in getting response from remote server for that I have written following script response got correctly but the data on the page is not displayed it gives “–“ in place of grid data. It’s because when actual page load in web browser it shows “-“ until loading is not completed after that it gives actual value after successful completion of loading of the page.

Script I have written is as follows :

<%
Response.Write("<SPAN class='tt'>Corn Futures (CZ)</SPAN>")
Const REMOTE_FILE_URL="http://www.cmegroup.com/trading/commodities/grain-and-oilseed/corn_quotes_globex.html"

Call ShowRemoteFile

Sub ShowRemoteFile
	Dim objXML, strContents, arrLines
	Dim x
	Set objXML=Server.CreateObject("Microsoft.XMLHTTP")
	
	'read text file...
	objXML.Open "GET", REMOTE_FILE_URL, False
	
	objXML.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
	
	objXML.Send
	strContents=objXML.ResponseText

	Set objXML=Nothing
	
	'split into lines and read line by line...
	arrLines=Split(strContents, VBCrLf)
	For x=0 To UBound(arrLines)
		If InStr(arrLines(x), "<Table>") or InStr(arrLines(x), "<th") or InStr(arrLines(x), "<tr") Then
			If not InStr(arrLines(x),"<i>") Then
			'If InStr(arrLines(x), "<Table>") or InStr(arrLines(x), "<tr>") or InStr(arrLines(x), "<td>") or InStr(arrLines(x), "xmlns:xs") Then
				Response.Write(arrLines(x)&"<br />")
			'End If
			End If
		End If
	Next
End Sub
%>

[jhardman]

It looks to me like you need to find a better data source. The website you are pulling from is designed for human browsers, you need to find a webservice or some such. I think after you find a better source there will be no problem.
Jared

[vtp82]

First of all Thanks for your reply.
And is there any datasource which pools data from anther server rather then getting response and store into the string ? exactly what i want is the HTML Table object like DomElement from that page and display it on to my page.

[vtp82]

First of all Thanks for your reply.
And is there any datasource which pools data from anther server rather then getting response and store into the string ? exactly what i want is the HTML Table object like DomElement from that page and display it on to my page.