Yes it does.
It worked for me on CF 4.5 Solaris and CF 4.52 Win2k using native
drivers
and with the 'Enable retrieval of long text' checked in the CF admin.
Selects work by default, here's the syntax for inserts and updates.
<CFQUERY NAME="name" DATASOURCE="#DSN#">
INSERT INTO CLOB_TABLE(
ID,
CLOB_TEXT
)
VALUES(
<CFQUERYPARAM VALUE="#ID#" CFSQLTYPE="CF_SQL_INTEGER">
<CFQUERYPARAM VALUE="#CLOB_TEXT#" CFSQLTYPE="CF_SQL_CLOB">
)
</CFQUERY>
<CFQUERY NAME="name" DATASOURCE="#DSN#">
UPDATE CLOB_TABLE
SET CLOB_TEXT = <CFQUERYPARAM VALUE="#CLOB_TEXT#"
CFSQLTYPE="CF_SQL_CLOB">
WHERE ID = <CFQUERYPARAM VALUE="#ID#"
CFSQLTYPE="CF_SQL_INTEGER>
</CFQUERY>
HTH
P.
-----Original Message-----
From: "Smit [mailto:"Smit]
Sent: Wednesday, July 18, 2001 2:25 AM
To: CF-Talk
Subject: CLOBS in Oracle
Hi,
Can you please inform me if ColdFusion supports the CLOB datatype in
Oracle.
If yes, what is the proper code for querying CLOB data.
Also, where can I find a resource on writing queries in ColdFusion
for an
Oracle DB.
Thanks
Francois
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
