Good information, but it doesn't seem to be the problem, reason being: I'm
not using a stored proc to store the data. I'm pulling it out of the temp
location with a query and using an array and a loop to do a mass submit to
the permanent file. All of the other data types (dates, integer, single
string text) seem to work okay. Multi-string text (with spaces in them)
don't. The columns with the multi-string text have all been properly typed
(varchar 255, e.g.) and the temporary storage can be confirmed. Pulling it
out of temp storage and trying to permanently store it is problematic.
Thanks for your suggestion.
Israel Rose
> -----Original Message-----
> From: Dylan Bromby [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 27, 2001 3:04 PM
> To: CF-Server
> Subject: Re: How to Store Comments or Large Text Messages?
>
> i'm not an oracle guy, but your problem sounds similar to this so see if
> it
> helps in any way:
>
> in SQL server, if you use a stored procedure to insert into a varchar
> column
> (for example) and do not specify the length of the varchar column (which
> you
> set or it defaulted when you created the table) in the stored procedure,
> the data insert will truncate.
>
> ----- Original Message -----
> From: "Rose, Israel" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Thursday, September 27, 2001 11:38 AM
> Subject: How to Store Comments or Large Text Messages?
>
>
> > Along with other data, I'm incrementally inputting large text messages
> as
> > comments, saving them to a temporary file in an Oracle database, and
> > querying that file for final storage to a permanent record file in the
> same
> > database. At the last step in this process, I somehow lose all except
> the
> > first word of these messages. I know (according to Ben Forta Cold
> Fusion
> > 4.0, Note on Page 154) that ODBC drivers have a problem processing the
> > double quote (") mark seeing it as a statement terminator. But, since
> the
> > data is being stored in a temporary location (I can see the results of
> the
> > query from this location), I don't see how this could be even remotely
> > related. I am lost and/or way off base as to a solution. Could this be
> a
> > Cold Fusion problem or is this an Oracle problem?
> >
> > Israel Rose
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
