function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
bill hayhowbill hayhow 

Error looping through queryresult - limit 100?

In Visual Studio 2005, with classic ASP, I'm getting an error that does not occur either on my server or on other machines. 
When looping through a queryresult, I'm getting an 'unknown exception' at the 100th record.  Sample code looks like this:

Set sf_queryresult = SforceApi.Query("select Name, ID from account", False)
if sf_queryresult.size > 0 then
x = 0

For Each sf_record In sf_queryresult

x = x + 1

if x > ubound(saAccountList, 2) then

redim preserve saAccountList(2, ubound(saAccountList, 2) + 500)

end if

saAccountList(1, x) = sf_record("Name")

saAccountList(2, x) = sf_record("ID")


redim preserve saAccountList(2, x)

end if