Connecting Tech Pros Worldwide Forums | Help | Site Map

Reading text into varchar

Hayat
Guest
 
Posts: n/a
#1: Jul 20 '05
Hello,

I have a column (text datatype) and has to send an email as a text
(not attachment) using cdonts. I am reading the data from text column
storing in a varchar field and saying cdonts.body = [data].

This way I can send email to as a text format. Now, my problem is when
length of data is greater than the 8000 chars it truncates the rest of
the data.......and email I send is a truncated email.......loosing
imporatnt data.

How should I resolve this situation.......I am trying some different
ideas but not worked yet. Finally, I am writting the entire content in
a file and sending it as attachment but the reaquirement is to send it
as a body text.

Any ideas?

Let me know if you need more details!

Thanks,

-Hayat
www.mysticssoft.com

John Bell
Guest
 
Posts: n/a
#2: Jul 20 '05

re: Reading text into varchar


Hi

You may want to look at:
http://support.microsoft.com/default...EN-US;Q325492&

John

"Hayat" <info@mysticssoft.com> wrote in message
news:29e54c97.0310050024.268c40a1@posting.google.c om...[color=blue]
> Hello,
>
> I have a column (text datatype) and has to send an email as a text
> (not attachment) using cdonts. I am reading the data from text column
> storing in a varchar field and saying cdonts.body = [data].
>
> This way I can send email to as a text format. Now, my problem is when
> length of data is greater than the 8000 chars it truncates the rest of
> the data.......and email I send is a truncated email.......loosing
> imporatnt data.
>
> How should I resolve this situation.......I am trying some different
> ideas but not worked yet. Finally, I am writting the entire content in
> a file and sending it as attachment but the reaquirement is to send it
> as a body text.
>
> Any ideas?
>
> Let me know if you need more details!
>
> Thanks,
>
> -Hayat
> www.mysticssoft.com[/color]


Closed Thread