Re: Interesting jdbc problem regarding integer column qualifier and set

John Harrison <jharriso_at_slip.net> wrote:
> 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?

Range values for of any types can't be defined as string value. There is syntax mistaken, not jdbc problem

> Thanks!

-- 
----------------------------
E-mail: fia_at_ins.dn.ua