12,398,225 members (53,435 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 7-Jul-13 23:31pm
Updated 7-Jul-13 23:32pm
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 420 Richard MacCutchan 265 Richard Deeming 244 Karthik Bangalore 190 ppolymorphe 180
 OriginalGriff 6,548 ppolymorphe 2,625 Karthik Bangalore 2,572 Richard MacCutchan 2,017 F-ES Sitecore 1,977

Web01 | 2.8.160721.1 | Last Updated 8 Jul 2013