Android Question select id list form tabel in sql

arastoo said:

Hello friends?

I use the following command to get a specific sequence in the database
For example, where the ID is 1



My question is here

I get a list of different IDs as follows
List_id =>


What syntax should I use to get these lines in the database?


Thanks ?

Click to expand...

cur=sql.ExecQuery("SELECT * FROM tabel1 WHERE id ='1'")

or this ?
dim id as int = 1
cur=sql.ExecQuery("SELECT * FROM tabel1 WHERE id =' & id & "'")

It is a mistake to build a query like this.

Better is to use parametrized Queries.

Click to expand...

arastoo said:

Hello friends?

I use the following command to get a specific sequence in the database
For example, where the ID is 1



My question is here

I get a list of different IDs as follows
List_id =>


What syntax should I use to get these lines in the database?


Thanks ?

Click to expand...

cur=sql.ExecQuery("SELECT * FROM tabel1 WHERE di in (1,23,467,346,83685,2568,2) ")
OR
cur=sql.ExecQuery2("SELECT * FROM tabel1 WHERE id in (?,?,?,?,?,?,?);",Array(1,23,467,346,83685,2568,2))

arastoo said:

How can I introduce the list to Syntax Database?

Click to expand...

Dim MyList As List
    MyList.Initialize
    MyList.AddAll(Array As Int(34,674,3, 76,33,98,4))
    Dim sb As StringBuilder
    sb.Initialize
    sb.Append( " IN(")
    For i= 0 To MyList.size -1
        Dim f As Int =MyList.Get(i)
        If i = MyList.Size-1 Then
            sb.Append($"${f})"$)
        Else
            sb.Append($"${f},"$)
        End If
    Next
    Log(sb.ToString)  'displays as example: IN(34,674,3,76,33,98,4)
    Dim MyInClause As String = sb.ToString
    cur=sql.ExecQuery("SELECT * FROM tabel1 WHERE id " & MyInClause )