Hi everyone, I really need some help with the following problem:
We are upgrading our system from CF 5 to MX 7, and i have a query of queries
problem. My attached code is giving me this error:
The following information is meant for the website developer for debugging
purposes.
Error Occurred While Processing Request
Query Of Queries runtime error.
Query Of Queries runtime error.
Unsupported SQL type "java.sql.Types.CLOB".
The field WBLT_TEXT is the CLOB field. I have tried putting SELECT
CAST(WBLT_TEXT as VARCHAR) into the ListBullets query but I get exactly the
same error.
We are using Datadirect 3.5 drivers with a Type 4 JDBC Connection to an Oracle
10g RAC
Your help is greatly appreciated.
Ally
<CFQUERY name="ReadBltInfo" datasource="#Application.DSN#">
SELECT BLT_ID, BLT_PGEID, BLT_BULLETS
FROM WEBBULLETS
WHERE BLT_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#iCurrentElement_ID#" null="#yesNoFormat(NOT
Len(trim(iCurrentElement_ID)))#">
</CFQUERY>
<CFQUERY name="ListBulletsAll" datasource="#Application.DSN#">
SELECT WBLT_ID, WBLT_TEXT, WBLTELEM_ID
FROM WEBBLTS
WHERE WBLTELEM_ID = <cfqueryparam
value="#iCurrentElement_ID#" cfsqltype="CF_SQL_INTEGER" null="#yesNoFormat(NOT
Len(trim(iCurrentElement_ID)))#">
</CFQUERY>
<CFLOOP list="#ReadBltInfo.BLT_BULLETS#" index="ibltid">
<CFQUERY name="ListBullets" dbtype="query">
SELECT WBLT_TEXT
FROM ListBulletsAll
WHERE WBLT_ID = <cfqueryparam value="#ibltid#"
cfsqltype="CF_SQL_INTEGER" null="#yesNoFormat(NOT Len(trim(ibltid)))#">
</CFQUERY>
<CF_TEXTAREAFORMAT INPUT="#ListBullets.WBLT_TEXT#"
OUTPUT="textarea">
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276887
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
