Thanks,
I'd appreciate your help. I can use stored proc.
Segalla
- Original Message -
From: Daniel J. Cody <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 1:13 AM
Subject: Re: Inserting long string literals into an Oracle LONG column --
error!
One thing that I was trying before I learned about the
attribute was running the input through a stored procedure that broke it
up into 4k chunks and then inserted that array into the LONG column..
If you're interested, and have the means to run stored procs, lemme know
and I can try to dig out
om.br
- 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 thi
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 tag that I'd like to insert/update the value of into
> > >an Oracle LONG column. For simple and short values, t
Segalla -
The solution that I gave to Rueben at the beggining of this thread will
fix the problem for you as well. The 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 Oracle 8 on Li
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 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 theTab
At 01:53 PM 5/8/00 -0500, you wrote:
>I have a 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
>
>However, if I get too much text in that string literal
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 litera
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
Reuben -
If you're using 4.5.1 try the following code, you have to use a special
parameter() to get this to work:(this is obviously an
insert statement, but the idea is the same for an update)
insert into content (contentname, body, userid, datemod)
values ('#form.contentnam
I have a 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
However, if I get too much text in that string literal, I get an "ORA-
01704: string literal to
11 matches
Mail list logo
