Problem of MSXML2.XMLHTTP

Hi,

I have a server side of asp which generate rows of data from DB in real
time (around 1500KB of data, 4000 row of data)

my client side get the result using MSXML2.XMLHTTP

when the result is very small, e.g. 1 row, the result is as expected.

However, when the rows number grow , e.g. 4000 row, only the first 2 row
data is back.

is this the limit of MSXML2.XMLHTTP?

Here is my code....
'-------------------------------------------------


Set xhttpPost = creatobject("MSXML2.XMLHTTP")
With xhttpPost

.Open "GET", url, False
.send ""

Do While .readyState <> 4

DoEvents

Loop

wscript.echo .responseText
End With

Set xhttpPost = Nothing

Bob
Mon Aug 16 08:57:45 CDT 2004

Nick wrote:
> Hi,
>
> I have a server side of asp which generate rows of data from DB in
> real time (around 1500KB of data, 4000 row of data)
>
> my client side get the result using MSXML2.XMLHTTP
>
> when the result is very small, e.g. 1 row, the result is as expected.
>
> However, when the rows number grow , e.g. 4000 row, only the first 2
> row data is back.

Have you verified that the server-side page is actually returning the full
4000 rows?

>
> is this the limit of MSXML2.XMLHTTP?
>
> Here is my code....
> '-------------------------------------------------
>
>
> Set xhttpPost = creatobject("MSXML2.XMLHTTP")
> With xhttpPost
>
> .Open "GET", url, False
> .send ""
>
> Do While .readyState <> 4
>
> DoEvents
>
> Loop
>
> wscript.echo .responseText
> End With
>
> Set xhttpPost = Nothing

If the server-side page is actually returning the full 4000 rows, then I
suspect this to be a limitation of wscript.echo. Can anyone confirm that? I
don't see anything in the documentation about a size limit for the string
passed to the echo method.

Another possibility is that some character in your responseText string is
being mistaken for a string delimiter. Try:

Set xmldoc=.responseXML
xmldoc.save "debug.xml"

Look at the contents of debug.xml (which will probably be saved to the root
of the current drive. Enter the path of the folder you wish to use if you
don't want to save it to the root.)

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.