how can write requete between in preparedstatement

[manjava]

Hello,

i want to write this requete:

PreparedStateme nt st=c.prepareSta tement("SELECT a,b,c FROM table WHERE (a BETWEEN "+?+" and "+?+"+10) AND (b BETWEEN "+?+" and "+?+"+ 10) LIMIT 5 ");

in preparedstateme nt but signe error why can any tell what can write


thanks

[Dököll]

I am not sure what you are asking manjava...

What are you hoping to do?