I nutted out an alternative approach to using the GetRows as described in intial thread. Here is the code
'To extract the row start position I created an index of the recordset and compared where the values changed.
' Initialising statusChangeArr ay
statusChangeArr ay(scIndex) = 0
scIndex = scIndex + 1
Dim i
For i = 1 To MaxArraySize
if statusArray(0,( i-1)) <> statusArray(0,( i))...
colm1974
Last Activity: Oct 4 '07, 07:24 AM
Joined: Sep 5 '07
Location:
-
Hi Mark,
Thanks for reply. You are spot on in what I want to do. Ultimately the 'filtered' arrays must end up in javascript page and the way this is constructed limits how and when the arrays are constructed. It may end up that I have to use your suggestion in the end.
Not wanting to challange your knowledge (as I am sure its vastly greater than mine... I am only plodding through vbscript) but I did find 2 references...Leave a comment:
-
What is the correct syntax for the GetRows method
Hi,
I hope somebody can help. I have been trying to use the GetRows method but it only seems to work when there are no constants assigned.
aGetElement = rs_zgl_element. GetRows()
This works and I can select any array element I need from aGetElement. I can use Lbound, Ubound etc etc. In this case the recordset has in effect 2 columns and 197 rows. Column names are converted (int), name (varchar).
...
No activity results to display
Leave a comment: