nickgross19
asked on
asp -- passing an array to a sub
I have a subprocedure:
The parts argument receives an array. Here is how I am calling the sub:
matchingParts is an array that i am trying to give to the send_email function.
I do a test and use the Ubound() function to check the upper bound of the array before putting it into the subprocedure and it shows that there are indeed items in the array. When I check the ubound() value of the array parts in the subprocedure, I get 0 as the upper bound. So suddenly all the elements in my array are removed just by passing the array.
What is going on and how can i pass the array?
sub send_email(userid,parts)
The parts argument receives an array. Here is how I am calling the sub:
send_email(user_id,matchingParts)
matchingParts is an array that i am trying to give to the send_email function.
I do a test and use the Ubound() function to check the upper bound of the array before putting it into the subprocedure and it shows that there are indeed items in the array. When I check the ubound() value of the array parts in the subprocedure, I get 0 as the upper bound. So suddenly all the elements in my array are removed just by passing the array.
What is going on and how can i pass the array?
ASKER
tried it, and once the array is passed, the ubound() function returns 0.
can you please show the full code of that function?
ASKER
sub send_email(userid,parts)
dim htmlParts
dim xyz
response.Write("passed ubound: "&ubound(parts)&"<br>")
As you can see, right away i get a 0 returned by the ubound() function. The only thing that happens before this is two dim statemtns
sounds ok, can you please show the relevant code that builds the array, and calls send_mail function?
ASKER
This is the code that builds the array:
do while not ngrs2.eof
if part_ic = "" then
part_ic = 0
end if
ReDim Preserve mathcingParts(part_ic)
mathcingParts(part_ic) = ngrs2.Fields("ID")
part_ic = part_ic + 1
ngrs2.MoveNext
loop
ASKER
I got it to work somehow, i don't know what i was doing wrong...
Thanks for your help.
Thanks for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
An array with Ubound = 0 has one element. Arrays start counting at 0. If you have an empty array, it will return -1 on Ubound.
send_email user_id,matchingParts