12,073,325 members (72,396 online)
Rate this:
See more:
```Dim selected As String = ""
For Each node As RadTreeNode In treedetails.Nodes
If node.Checked = True Then
selected += node.Value + ""
End If
Next
tn &= " and a.zbaid in (" & selected & ")"```

when i check though breakpoints this is whats happening
`select distinct a.empno,a.name,a.empdesignation ,to_char(b.dtleavefrom,'dd-Mon-yyyy') as dtleavefrom  ,to_char(b.dtleaveto,'dd-Mon-yyyy') as dtleaveto,c.desp, DECODE(b.dtleaveto -b.dtleavefrom,0,1,b.dtleaveto -b.dtleavefrom) dAYS   from tt.employee a join dilpreet.leavedetails b on a.empno = b.empid join ranu.leavemaster c on b.leaveid = c.leaveid  where (b.status='C')  and b.dtleavefrom LIKE '%JAN-13%' and a.zbaid in (201123208210166212)`

the a.zbaid feild shows my id like this when it is supposed to show it like (201,123,208,210,166,212)
Posted 8-Jul-13 0:31am
Edited 8-Jul-13 0:32am
v2

Rate this:

## Solution 2

```Dim selected As String = ""
Dim sep As String = ""
For Each node As RadTreeNode In treedetails.Nodes
If node.Checked = True Then
selected +=  node.Value & ","
End If
Next
selected=selected.Substring(0, selected.Length - 1)
tn &= " and a.zbaid in (" & selected & ")"
```
Rate this:

## Solution 1

IN clause requires a commas separated list: so add your comma in the loop:
```Dim selected As String = ""
Dim sep As String = ""
For Each node As RadTreeNode In treedetails.Nodes
If node.Checked = True Then
selected += sep + node.Value
sep = ","
End If
Next
tn &= " and a.zbaid in (" & selected & ")"
```
But you would be better off using a StringBuilder, or assembling a List of strings, and using String.Join.

move separator to before clause...oops - OriginalGriff[/edit]
v2
a2ulthakur 8-Jul-13 7:53am

still it produces output like this

select distinct a.desgid,a.empno,a.name,a.empdesignation ,to_char(b.dtleavefrom,'dd-Mon-yyyy') as dtleavefrom ,to_char(b.dtleaveto,'dd-Mon-yyyy') as dtleaveto,c.desp, DECODE(b.dtleaveto -b.dtleavefrom,0,1,b.dtleaveto -b.dtleavefrom) dAYS from tt.employees a join dilpreet.leavedetails b on a.empno = b.empid join ranu.leavemaster c on b.leaveid = c.leaveid where (b.status='P' or b.status='PR' or b.status='AP') and b.dtleavefrom LIKE '%FEB-13%' and a.zbaid in (201123,208,210,)
OriginalGriff 8-Jul-13 8:03am

:doh: I blame lack of coffee this morning - I have changed my code to fix it...

Top Experts
Last 24hrsThis month
 OriginalGriff 490 Dave Kreskowiak 315 CPallini 295 CHill60 160 ProgramFOX 160
 Dave Kreskowiak 2,511 OriginalGriff 2,164 Richard MacCutchan 1,675 CPallini 1,387 CHill60 1,219