I have a textarea tag that I'd like to insert/update the value of into
an Oracle LONG column. For simple and short values, the following works
fine:
update theTable set theCol = '#form.textareaname#' where where clause
However, if I get too much text in that string literal, I get an "ORA-
Reuben -
If you're using 4.5.1 try the following code, you have to use a special
parameter(cfqueryparam) to get this to work:(this is obviously an
insert statement, but the idea is the same for an update)
cfquery name="addcon" datasource="#data#"
insert into content (contentname, body,
Access' ODBC driver has (or used to, not sure if it's fixed) a limit of
16K on memo fields, even though 64K is supported by the DB. You might
be seeing a similar problem. You might want to do a little research
into the ODBC driver's limitations.
Kevin
Kevin Miller
IT Systems Resource Manager
I have the same problem CF on NT and Oracle 8 on Linux.
I'm looking for ideas too.
Segalla
- Original Message -
From: Reuben King [EMAIL PROTECTED]
Newsgroups: cf-talk
To: [EMAIL PROTECTED]
Sent: Monday, May 08, 2000 3:53 PM
Subject: Inserting long string literals into an Oracle LONG
At 01:53 PM 5/8/00 -0500, you wrote:
I have a textarea tag that I'd like to insert/update the value of into
an Oracle LONG column. For simple and short values, the following works
fine:
update theTable set theCol = '#form.textareaname#' where where clause
However, if I get too much text in that
In [EMAIL PROTECTED], Jennifer
([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
At 01:53 PM 5/8/00 -0500, you wrote:
I have a textarea tag that I'd like to insert/update the value of into
an Oracle LONG column. For simple and short values, the following works
fine:
update theTable
Segalla -
The solution that I gave to Rueben at the beggining of this thread will
fix the problem for you as well. The cfqueryparam is new in 4.5 so its
a new solution for many.
Shout if you have any other questions :)
.djc.
Fernando Segalla wrote:
I have the same problem CF on NT and
At 05:42 PM 5/8/00 -0500, you wrote:
In [EMAIL PROTECTED], Jennifer
([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
At 01:53 PM 5/8/00 -0500, you wrote:
I have a textarea tag that I'd like to insert/update the value of into
an Oracle LONG column. For simple and short values, the
- Original Message -
From: Daniel J. Cody [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 08, 2000 8:30 PM
Subject: Re: Inserting long string literals into an Oracle LONG column --
error!
Segalla -
The solution that I gave to Rueben at the beggining of this thread will
fix
9 matches
Mail list logo