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 1 2664
Hi
You may want to look at: http://support.microsoft.com/default...EN-US;Q325492&
John
"Hayat" <in**@mysticsso ft.com> wrote in message
news:29******** *************** ***@posting.goo gle.com... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dariusz |
last post by:
Below is part of a code I have for a database. While the database table is
created correctly (if it doesn't exist), and data is input correctly into
the database when executed, I have a problem when reading out the data into
the PHP variables / array.
It should be displaying the information out in the following way, using
the PHP array:
n_date, n_headline, n_summarytext, n_fulltext
|
by: Boris Wilhelms |
last post by:
Hello all,
at first, sorry for my bad English, I’ll give my best
We have a strange problem reading Text- and VarChar-Fields.
Our configuration:
-Windows 2003 Server
-MySQL Server 3.23.36
-MyODBC 3.51
|
by: adrian |
last post by:
hi all
this is my first post to this group, so pls bear with me while i try
to make some sense.
i am trying to create a sproc which uses dynamic sql to target a
particuar table eg. '.' and perform
some actions.
i am using @tableID as a passes parameter for the sproc.
|
by: Rick Caborn |
last post by:
Does anyone know of a way to execute sql code from a dynamically built
text field?
Before beginning, let me state that I know this db architecture is
built solely for frustration and I hope to make it better soon.
Unfortunately, there is never a non-crucial time in which we can do an
upgrade, so we are stuck for now.
Point 1:
There are multiple tables: students, courses, cross-reference
|
by: Matik |
last post by:
Hello to all,
Maybe first small introduction:
- SQLServer 2000 SP3,
- XP Pro EN,
- ActiveX,
- SP in database
It should working like this.
There is a instanse of an object working, which recieves "telegramms"
| |
by: Karen Sullivan |
last post by:
Hi, all. I'm fairly new to SQL, and I have been trying to create a table
from a text file. I have been looking at this for days, and can't find the
problem. I get a syntax error " Line 55: Incorrect syntax near
'DateUpdated'." Here is the query. Any suggestions would be appreciated,
as I am trying to learn and improve.
Use ACH
go
if exists (select * from dbo.sysobjects where id =
|
by: panic attack |
last post by:
Hello everbody,
Our system is using Sql Server 2000 on Windows XP / Windows 2000
We have a text file needs to be imported into Sql Server 2000 as a
table.
But we are facing a problem which is,
Sql Server claims that it has a character size limit ( which is 8060 )
so it cant procceed the import operation if the text file has a record
bigger then 8060.
The records , in the text file, have a size bigger then 8060. So we
wont be able to...
|
by: ChrisFrohlich |
last post by:
ASP.NET 2.0 with Text DataTypes:
I've got a similar question going in the SQL group, but I was wondering if
anyone has successfully implemented reading/writing character data from a
Text datatype column in SQL 2000. I know there's a Varchar(MAX) feature in
SQL2005, but my budget mocks me right now and I need to do it in SQL 2K.
Situation:
I'm building a resume DB, and for ease of input, I'd really like to be able
to use a single...
|
by: Krishna Ladwa |
last post by:
In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears when you convert the varchar column to text column.
Do this through Enterprise Manager Console
Create a New table with a column as varchar datatype from Enterprise Manager table created Open the table and add one row Successfully added the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |