To ensure that we dont populate a IN (xxx) with empty data strip() and check:
|
if access != "": |
|
if wes.len == 0: |
|
acc.add(" WHERE " & accessC & " in ") |
|
acc.add("(") |
|
else: |
|
acc.add(" AND " & accessC & " in (") |
|
for a in split(access, ","): |
|
acc.add(a & ",") |
|
acc = acc[0 .. ^2] |
|
acc.add(")") |
To ensure that we dont populate a
IN (xxx)with empty datastrip()and check:nim_sqlbuilder/src/sqlbuilderpkg/select.nim
Lines 25 to 34 in 499dc88