I thought <cfqueryparam> couldn't/shouldn't be used in INSERT
statements?
(I don't remember where I heard this. I think from a thread months
ago on
this list.) Where are people using them in their code? I use them
in
every SELECT statement I make, but not in INSERT, UPDATE, and DELETE.
Any
thoughts?
> -----Original Message-----
> From: Peter Stolz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 8:25 AM
> To: CF-Talk
> Subject: RE: CLOBS in Oracle
>
>
> 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
