Apex Code Development You need to sign in to do that
Don't have an account?
bill 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")
Next
redim preserve saAccountList(2, x)
end if