Android Question Parameter Query With IN keyword

[jahswant]

I use this query. How to send this data in a Parameterized SQL Query ?

SELECT * FROM MXI mxi WHERE mxi.item_id in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)

Current :

SELECT * FROM MXI mxi WHERE mxi.item_id in ?

 

[Mahares]

SELECT * FROM MXI mxi WHERE mxi.item_id in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)

rs= sql1.ExecQuery2("SELECT col1 FROM table1 WHERE col3 IN (?, ?,?, etc)", Array As Int(22,21,89,etc))

You can also put the values ina list and use that for the array part. Also, you can fancy it a little better with stringBuilder
Bonne Nuit

 

[Mahares]

How to send this data in a Parameterized SQL Query ?

Here is the complete code if you want to spruce it up with string builder and parameterized query:

Dim MyList As List
    MyList.Initialize
    MyList.AddAll(Array As Int(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20))
    Dim sb As StringBuilder
    sb.Initialize   
    sb.Append( " IN(")
    For i= 0 To MyList.size -1
        Dim f As String = "?"
        If i = MyList.Size-1 Then
            sb.Append($"${f})"$)
        Else
            sb.Append($"${f},"$)
        End If
    Next
    rs= SQL.ExecQuery2("SELECT * FROM MXI mxi WHERE mxi.item_id " & sb.ToString, MyList)

EDITED LATER without a full test: You may have to have an array like this to execute the query:

Dim s() As String = Array As String(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)

And use:

  rs= SQL.ExecQuery2("SELECT * FROM MXI mxi WHERE mxi.item_id " & sb.ToString, s)

 

[jahswant]

Thanks let me try it now later !