| Author |
 Topic Search  Topic Options
|
ljamal 
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 24 August 2003 at 8:42pm |
|
IsNull should work. Try
IsNull (arrRound(3,1))
note the additional ')' to close the ISNull Function
|
|
|
 |
Mikeap
Newbie
Joined: 12 March 2003
Location: United States
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:03pm |
Microsoft VBScript runtime error '800a0009'
Subscript out of range: '[number: 1]'
<% If IsNull (arrRound1(3,1)) Then
arrRound1(3,1) = "None"
Response.Write(arrRound1)
End If%>
|
|
b_bonnett
Mod Builder Group
Joined: 16 April 2003
Location: New Zealand
Status: Offline
Points: 275
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:07pm |
Thats because you used Response.Write(arrRound1), not Response.Write(arrRound1(3,1)).
Blair
|
|
|
|
Mikeap
Newbie
Joined: 12 March 2003
Location: United States
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:09pm |
I changed it to this right after posting that:
If (arrRound1(3,1)) = "" Then
arrRound1(3,1) = "None"
Else
Response.Write(arrRound1(3,1))
End If
Still does not work ...
|
|
Mikeap
Newbie
Joined: 12 March 2003
Location: United States
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:10pm |
|
I get an object out of range error ...
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:15pm |
|
How many rows are in the recordset? How many columns?
The first number in the array represents the column you want to display. The second number the row. Remember that arrays begin with 0, so the first olumn in the first row would be arrayName(0,0).
|
|
|
|
b_bonnett
Mod Builder Group
Joined: 16 April 2003
Location: New Zealand
Status: Offline
Points: 275
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:18pm |
Comment out that code and put the following in there:
Response.Write "Array Dimensions: " & UBound(arrRound1) & " x " & UBound(arrRound1, 2) |
Then post what it says here.
Blair
|
|
|
|
Mikeap
Newbie
Joined: 12 March 2003
Location: United States
Status: Offline
Points: 37
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 August 2003 at 9:18pm |
Their is only one row in the recordset and five columns. In literal the column I want to use is number four which means it's number three here.
So displaying arrRound1(3,0) works fine because their is one row.
Displaying arrRound1(3,1) does not because there is no "second" row.
So I want to put some IF statements to display something else so the page continues.
|
|
