<MethodAPI response = "Failure. There were problems with running the query, please verify your parameters" ></MethodAPI>
Yes. We have changed the login credentials in our code and have verified that they are correct. (They are my login credentials.)
No. We have not made any other changes to the code.
Strangely, the code works at times and then goes back to not working.
sSelectFields = "FullName"
sSelectFrom = "Customer"
sSelectWhere = "SerialNo=" & iSerial & " AND " & "CodeNo=" & iCode
sSelectGroupBy = ""
sSelectHaving = ""
sSelectOrderBy = ""
'Call the MethodAPI to get the dataset
sResult = wbsMethodAPI.MethodAPISelect_DataSetV2(sCompanyAccount, sUserName, sPassword, _
"", datResponse, sSelectFrom, sSelectFields, sSelectWhere, sSelectGroupBy, sSelectHaving, sSelectOrderBy)
wbsMethodAPI = Nothing
if gdebug then response.write(sResult)