Reading text into varchar

[Hayat]

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.......loo sing
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

https://www.mysticssoft.com

[John Bell]

Re: Reading text into varchar

Hi

You may want to look at:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325492&

John

"Hayat" <info@mysticsso ft.com> wrote in message
news:29e54c97.0 310050024.268c4 0a1@posting.goo gle.com...[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.......loo sing
> 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]