Hi,

I have 24 checkboxes all with the same naming convention, each box has a value ranging from 1 to 23, what I need to do is fill in the gaps with a 0 value where the user doesn't select a value.

So lets say that the user selects:

1,2,3,4,5,6,7,15,18,19,20

what I want to do is use the split function on the next page to convert into an array but then I want to redim the array and fill in the missing values, so I would end up with:

1,2,3,4,5,6,7,0,0,0,0,0,0,0,15,0,0,18,19,20,0,0,0


is it possible to do this and if so how

Thanks for any help
Peter

Isn't 1 to 23 = 23? Do you mean 0 to 23?

My suggestion would be to do something like this (my VBScript might be a little rusty)...

Dim arySelected
Dim aryPossible(23)
Dim i

arySelected = Split(Request.Form("checkboxes"), ",")

'Create all the zeros for all possibilities
For i = 0 To UBound(aryPossible)
   aryPossible(i) = 0
Next
'Go thru all the selected ones and fill in their
'respective elements in the "possible" array
For i = 0 To UBound(arySelected)
   aryPossible(arySelected(i)) = arySelected(i)
Next

Peter
------------------------------------------------------
Work smarter, not harder.

Thanks Peter that was exactly what I was looking for thank you, on another note, when I am looping through the array I am getting the correct results but I am losing the leading zeros, the section in question is:

If LastHour <> 0 Then
   TimeQuery = TimeQuery & "(time>" & LastHour & " & "
End If

The LastHour containing the array, so 02 become 2, I have tied to find a fumction that will maintain the zero but to no avail, any ideas on how to get around it, this is using VBscript

Many thanks again
Peter

You'll have to pad the integer yourself.

If LastHour < 10 Then
   LastHour = "0" & LastHour
End If