Assigning a Split Array to an ASP Multidimensional Dynamic Array

Hi,

I have a recordset with a single column, where each cell contains a number of tilda separated values, for example:
| one~two~three |
| four~five~six |

which I want set up into a two dimensional array, ie:
| one | two | three |
| four | five | six |

I keep getting 'Subscript out of range: 'arrArray'' error, and I assume I am doing something fundamentally wrong - can anyone help out please?

Thanks in advance!
~ Bob
If Not(objRefCursor.eof) And Not(objRefCursor.bof) Then
		
    ReDim arrArray(objRefCursor.RecordCount, nColumns)
		
    For nRowCount = 0 To nRows
        arrArray(nRowCount) = Split(objRefCursor(nRowCount), "~")
    Next
			
  End If

Open in new window

FrostbiteXIIIAsked:
Who is Participating?
 
FrostbiteXIIIAuthor Commented:
Looks like I just missed the second index from my arrArray line... Bah...

This seems to (roughly) work, for anyone else needing it.
If Not(objRefCursor.eof) And Not(objRefCursor.bof) Then
                
    ReDim arrArray(objRefCursor.RecordCount, nColumns)
                
    For nRowCount = 0 To nRows
        arrArray(nRowCount, 0) = Split(objRefCursor(nRowCount), "~")
    Next
                        
End If

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.