Unix Technical Forum

Reading text into varchar

This is a discussion on Reading text into varchar within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, I have a column (text datatype) and has to send an email as a text (not attachment) using ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 07:12 PM
Hayat
 
Posts: n/a
Default Reading text into varchar

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 07:12 PM
John Bell
 
Posts: n/a
Default 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...
> 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



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:46 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com