Clob Datatype Cast for Queries on Query

[Armtusk]

Hi ,
I am getting a Query of Queries runtime error when I try to do a QoQ on
query which has a column with the clob datatype. The original query is
basically querying a database table which has a column whose datatype is CLOB.
And when I try to do query that original query object, I get the following
error.

Query Of Queries runtime error.
Unsupported SQL type "java.sql.Types.CLOB".

This was working just fine in CFMX 6.1 and has been erroring out once
we installed CFMX 7. Any suggestion will be appreciated. Thanks in advance.

Mishra.

[Bill Sahlas]

What database are you going against? I've just tested this with our
oracle_9i_merant server. No problems here. Please give me as much
connection details as possible.

--
Bill Sahlas
ColdFusion QA

"Armtusk" <webforumsuser@macromedia.com> wrote in message
news:cv35i4$gs3$1@forums.macromedia.com...

> Hi ,
> I am getting a Query of Queries runtime error when I try to do a QoQ
> on
> query which has a column with the clob datatype. The original query is
> basically querying a database table which has a column whose datatype is
> CLOB.
> And when I try to do query that original query object, I get the following
> error.
>
> Query Of Queries runtime error.
> Unsupported SQL type "java.sql.Types.CLOB".
>
> This was working just fine in CFMX 6.1 and has been erroring out
> once
> we installed CFMX 7. Any suggestion will be appreciated. Thanks in
> advance.
>
> Mishra.
>
>
>