Database Entry Problems

gmoney060 · November 4th, 2004, 08:46 PM

Hello. The script I am working on is below. It is saying that the array value "SplitUser(0)" Is out of range. If I would put the code, in red, into the actual script, all the arrays i am trying to get do have a value, but for some reason they are like not being found. Any help would be great! Thanks a lot! **THE RED IS NOT ACTUALLY IN THE SCRIPT I WANT, JUST DID IT TO MAKE SURE THERE ARE VALUES FOR THE ARRAY ELEMENTS!

Code:

For UserCount = LBound(Users) To UBound(Users)
    SplitUser = Split(Users(UserCount),",",-1,1)
    PlayerInfo.AddNew
    For SplitCounter = LBound(SplitUser) To UBound(SplitUser)
        Response.Write SplitUser(SplitCounter) & "<BR>"
    Next
    PlayerInfo("TournamentID") = TournamentID
    PlayerInfo("PinNumber") = SplitUser(0)
    PlayerInfo("FirstName") = SplitUser(1)
    PlayerInfo("LastName") = SplitUser(2)
    PlayerInfo.Update
Next

rajanikrishna · November 4th, 2004, 09:29 PM

Hello,

  I think you generated array by storing a list of values from a database.

while not Rs.EOF
   strValues=strValues & Rs(fieldname) & ","
   Rs.MoveNext
wend

At this situation, you should not loop the counter upto UBOUND

For UserCount = LBound(Users) To UBound(Users)-1
    SplitUser = Split(Users(UserCount),",",-1,1)
    PlayerInfo.AddNew
    PlayerInfo("TournamentID") = TournamentID
    PlayerInfo("PinNumber") = SplitUser(0)
    PlayerInfo("FirstName") = SplitUser(1)
    PlayerInfo("LastName") = SplitUser(2)
    PlayerInfo.Update
Next

Hope this works.

--------------
Rajani

rajanikrishna · November 4th, 2004, 09:30 PM

Oh!

Instead of LBound()

You can start the loop from 0.

---------
Rajani

gmoney060 · November 4th, 2004, 10:08 PM

nope, sorry... Still does not work

happygv · November 9th, 2004, 08:19 AM

Hi Gmoney060,

Quote:

quote:It is saying that the array value "SplitUser(0)" Is out of range.

Chances are, the array can hold nothing at that point, so that even when used the ZERO subscript it returns error. Check if the array has something in it, using

Code:

If UBOUND(SplitUser)>0 then
... use the FOR LOOP here.
End If

Check that before you run a for loop for that.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection