Array never changes

[Dan Beanweed]

The user can choose either a region or a country on a form and submits the form to this page.
First, code gets a list of events for the country or for the region:

  . . . 
   if (request.form("country_sel") < 0) then
      allevents = getEventsByRegion(request.form("reg"),1)
   else
      allevents = getEvents(request.form("country_sel"),1)
   end if
   . . .

Later, the page should loop through all the events extracted for the country or region and at each loop get a list of particular information for the event:

 . . . 
   <% for a=0 to ubound(allevents,2)
    evid = allevents(0,a)
    eventinfo = getEventInfo(evid,1)
    if isarray(eventinfo) then
        evtitle = eventinfo(1,0)
   . . . 

But what is happening is the loop only ever gets the first event's info. For example, if I have

Event Id:<%=evid%> and Event Title:<%=evititle%>

what I get is

Event Id:1 Event Title:first event
Event Id:2 Event Title:first event
Event Id:3 Event Title:first event
. . .

It is like the code is preserving the array "eventinfo" in spite of the call to the function.
What gives? Explain please!

[markrawlingson]

Hi Dan,

Welcome to TSDN. Please use proper code tags when you are posting, makes it much easier to read!

It looks like you are only ever referencing record 0 within the eventinfo array.

For instance..

'here you are using a function called getEventInfo() to set eventinfo up as what looks to be a multi-dimensional array
eventinfo = getEventInfo(evid,1)
 
if isarray(eventinfo) then
   'And here, you are setting the value of column 1, record 0. Which will always pull the information from that location since you are looping and always setting the same indice values.
   evtitle = eventinfo(1,0)
End If
 

That is, unless your getEventInfo() function writes different information to the eventinfo array during each loop. If that is the case please show the code behind that function.

Sincerely,
Mark