In <[EMAIL PROTECTED]>, Benjamin Smedberg ([EMAIL PROTECTED]) in a
fit of unbridled passion, wrote:
> > =A0I can't figure out how to select=A0the CLOB data type =
> > using=A0CFQUERY from an
> > Oracle database and display it in a table using CFOUTPUT.=A0 Does =
> > anyone have
> > the solution?=A0
>
> There is not an easy solution...CF does not (yet) support LOB datatypes. But
> I wrote a tag that will do this for Oracle8 CLOBs and BLOBs. If you want it,
> email me off-list. And don't send HTML email, please
Allaire claims support for large text objects since 4.x according to the
readme's I've seen on the subject. However, as I said, with 4.5 CF hung
whenever it tried to do a select with a clob column in it. But, as luck
would have it, just last week Allaire released the 4.5.1 server update
and after installing this, my problems went away entirely.
And for anyone who hasn't used the Intermedia Text engine built into
Oracle 8i, I _highly_ recommend it. It beats the crap out of the verity
implementation inside CF, is just as (if not more) functional as the
$200k+ full VDK licensing from Verity, and is built into every license
of Oracle 8i. I've only been using it for about 2 weeks now, but so far
everything I've seen of it has knocked my socks off!
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
