tags:

views:

54

answers:

0

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