Getrows from a stored procedure not creating array

[colby]

Hi
I am running a stored procedure
which returns id's that I can loop through.

my problem is if I try to use getrows to put the data into
an array format the the array does not seem to be populated.

anyone any ideas
Thanks in advance

 

[mwolf00]

Can you show your code?

set rs = cn.execute("select fieldName from tableName&quot

if not rs.eof then resultArr = rs.getRows()

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook

 

[colby]

Hi
I have stumble accross the answer
it populates it as a 2d array.
I was trying to read a 1d array.

Doh!
Sorry for the waste of time.

colby
(one of the Universe's better products).

 

[Tarwn]

Just a note, it populates it completely ***-backwards. In other words, instead of populating the first dimension as the fields and the second dimension as the record indexes, like every other person on the planet would consider doing it, the getRows populates the array with the first index as record and second index as field number.

At least I think I have that right, verytime I think about it I end up confused about practical array building

-Tarwn

_{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048