Hi,
This is my part of code (classic asp):
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = dbconn
cmd.CommandText = "test"
cmd.CommandType = 4
cmd.Parameters.Refresh
cmd.Parameters("@test") = test
Set rsGetGroupMemberList = cmd.Execute
dim rs, Cols, Rows
rs = rsGetGroupMemberList.GetRows
rsGetGroupMemberList.Close
Set rsGetGroupMemberList = nothing
Rows = UBound(rs, 2)
Cols = UBound(rs, 1)
For x = 0 to Rows
For y = 0 to Cols
response.write rs(y, x)
Next
Next
// In my code above, Rows will return 5 and Cols will return 21. But apparently, it only can display the record at the 1st,2nd,3rd,20th,21th column. The rest in between 3rd and 20th column can't be displayed nor retrieved. Anyone knows the problem?
Thanks