Android Question Join sqlite with condition where

[FabioCirillo]

hi,
i've this code:

Dim cursor As Cursor
cursor = sqldb.ExecQuery("SELECT partecipanti.id,squadre.nome FROM partecipanti JOIN squadre ON partecipanti.idsquadra=squadre.id WHERE partecipanti.idtorneo =?", Array As String(frmtorneo.idtorneo))

and in this code there's an error, the error message is: "Too many parameters"

where am I wrong?

 

[tipallandgo]

ExecQuery only accepts 1 parameter. You can try building the string query first to include your parameters before calling ExecQuery.

 

[FabioCirillo]

Sorry but how?

 

[sorex]

did you try it like this?

Dim cursor As Cursor
cursor = sqldb.ExecQuery("SELECT partecipanti.id,squadre.nome FROM partecipanti JOIN squadre ON partecipanti.idsquadra=squadre.id WHERE partecipanti.idtorneo =" & frmtorneo.idtorneo)

 

[FabioCirillo]

Good perfect thx bye