So this is what i did to fix the output
SELECT number_content,
varchar2_content,
TO_CHAR(date_content, 'DD-MON-YYYY') AS date_content,
clob_content AS TXT,
DBMS_LOB.getlength(blob_content) AS blob_length
FROM lob_tab
<cfoutput query="GetXML" >
<CFSET base64 = toBase64(#GetXML.TXT#)>
<CFSET base64 = tostring(base64)>
TEST #base64#
<cfdump var="#getXML#">
</cfoutput>
On Dec 11, 3:30 pm, Manno <[email protected]> wrote:
> I am having trouble output text string with the CLOB contraint.
> I enable the option in the admin, set the query param to recognize it
> but it gives me this error.
> If anyone has any idea on this subject i could use the help.
> Error
> inconsistent datatypes: expected - got CLOB
>
> SELECT *
> 12 : FROM lob_tab
> 13 : Where clob_content = <cfqueryPARAM value = "#clob_content#"
> CFSQLType = "CF_SQL_CLOB">
> 14 : </cfquery>
>
> Thanks
> Manuel
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the "Houston ColdFusion
Users' Group" discussion list.
To unsubscribe, send email to [email protected]
For more options, visit http://groups.google.com/group/houcfug?hl=en
-~----------~----~----~----~------~----~------~--~---
