Android Question Select from Spinner and Query

[sigster]

Hi

I am try to Query when I try to use Spinner I get nothing

Cursor1 = SQL1.ExecQuery("SELECT * FROM colorkode WHERE name = '" & Spinner_select.SelectedItem & "' AND number BETWEEN " & Txt_from.Text & " AND " & Txt_to.Text & "")

 

[derez]

Cursor1 = SQL1.ExecQuery2("SELECT * FROM colorkode WHERE name = ? AND number BETWEEN ? AND ?" array as string( Spinner_select.SelectedItem ,  Txt_from.Text, Txt_to.Text ))

 

[sigster]

Thanks