Interesting jdbc problem regarding integer column qualifier and set

Hey All ...

I've got an interesting problem (I think) concerning the coding of a jdbc query with an
integer column qualifier against a set of values:

select ... from table
where integerColumn in (rangeOf Values)

Basically, the column is integer, and the range of values most simply needs to be a string
value (something like "12,133,10,0,154) ... and you receive a type conflict during execution.

Can anyone think of a straight-forward approach for an jdbc solution to this?

Thanks! Received on Sun Dec 26 1999 - 00:18:14 CST