PreparedStatement: variable amount of placeholders

T

Timo Nentwig

Hi!

SELECT * FROM foo WHERE bar IN (?)

"?" shall be replaced by a variable count of arguments which I don't know at
compile-time. Is this what PreparedStatement.setArray() is good for? Seems
that there are no wrapper classes that implement Array...

TIA
Timo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PreparedStatement + "order by ?" 13
I'm tempted to quit out of frustration 1
Problem with comparing huge amount of strings 10
Variable Arg Lists to PreparedStatements 7
FAQ 5.24 All I want to do is append a small amount of text to the end of a file. Do I still have to 0
Efficient format for huge amount of data 21
dynamically allocate array variable of type LPWSTR 10
Amount of bits needed (as a compile time constant) 11

Members online

Total: 31 (members: 3, guests: 28)
Robots: 322

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,010
Latest member
MerrillEic

Latest Threads

Top