Brett:
Many, many thanks for this. I didn't try it without specifying the
cf_sql_type, but it worked perfectly.
Josh
On Wed, 2002-03-13 at 11:43, B Schlank wrote:
> Yes you can do this.
>
> Use CFQUERYPARAM and it should work fine. You might have to specify the
> CFSQLType as CF_SQL_BLOB, but try it without first.
>
> insert into testLong(characters, data)
> VALUES(4100, <CFQUERYPARAM VALUE="#value#">);
>
>
> -- Brett
>
> At 03:26 PM 3/11/2002 -0800, you wrote:
> >There are different restrictions under different versions of Oracle,
> >I believe your version has a restriction of 4095/6 characters per
> >"transmission across the wire". I've seen others having to put
> >together a special SP to concat numerous strings together to get
> >around this limitation. Earlier versions I think had a limitation
> >of 2047 chars / transmission. I have heard of similar restrictions
> >with ODBC as well...
> >
> >Anyone else?
>
>
>
> >Steve
> >
> >At 05:49 PM 3/11/2002 -0500, Josh Freeman wrote:
> > >I'm running Coldfusion 5.0 on a RedHat 7.2 box connected via Native
> > >Drivers to an Oracle 8.1.7 database. I am getting the following error
> > >whenever I attempt to insert a record of type long over about 4000
> > >characters:
> > >
> > >
> > >Oracle Error Code = 1704
> > >
> > >ORA-01704: string literal too long
> > >
> > >SQL = "insert into testLong(characters, data)
> > >VALUES(4100, {a whole lot of zeros})
> > >
> > >Any help would be greatly appreciated. This worked fine on my old setup,
> > >which was a CF 4.01 connected to Oracle 7.1.3.4 via ODBC.
> > >
> > >Thanks.
> > >
> > >Josh Freeman
> > >
> > >--
> > >Josh Freeman
> > >Technical Manager
> > >Center for Assistive Technology and Environmental Access
> > >
> > >
> >
>
______________________________________________________________________
Macromedia ColdFusion 5 Training from the Source
Step by Step ColdFusion
http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
