Scripting Help

Hello! I'm running the below Script and I get this error:

Error Type:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: '[number: 1]'
/t1/database/perfmgmt/newsite/manager/serviceobs/serviceObs2.asp, line 86


Here's My Script:

83 'Get userid of Agent from their name
84 nameArray = split(Agent,",")
85 First_Name = nameArray(0)
86 last_Name = nameArray(1)
87 query1 = "Select userid from Employees where Last_Name = '"&Last_Name&"' and First_Name = '"&First_Name&"'"
88 set objRS=Conn.execute(query1)
89 Agent = objRS("user_id")


What Causes this and How can I fix it?

Feel free to email me: Chris@thesouthside.net

Sounds like your array does not have a length of 2

Do yourself a favor and do a response.write with the array and see what it contains on the page.

Eric

Also I think the s in split should be capital, therefore it should be Split(str,"blah")

Eric

Also I think the s in split should be capital, therefore it should be Split(str,"blah")

Eric

VBScript isn't case sensitive, so he's ok on that one.