How to send windows attachment using senmail

[Andrew Mathews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Swapana Ghosh wrote:
| Hi
|
|        I am using sendmail in a program where the
| program scope is as follows:
|
|        1. customer id
|        2. Name
|        3. Reasons
|        4. Descriptions of the problems
|
|          4.1 Sending mail to customer for their
|              differnet issues
|          4.2 Sending the attachment file
|          4.3 Sending different topics as reference.
|
| Now the above 4 fields will be inserted in the
| database. For the fields 1,2,3 i have no problem but
| for the field 4 i have problems. I have kept a box in
| the html screen for all the fields. I hve kept
| database field type (text) for the field 4.  Now if
| i type the problem in the screen box then the field
| has not  problem i can insert it into the data base.
| But if i copy the  conetent and paste it in the box
| then it is giving insertion failure.
|
| My question is as follows:
|
|         1. How can i insert the field into the
|            database when the field is as i described
|            - copy and paste in the screen.
|         2. How can i send an attachment through
|            the sendmail.
|
| Pl. also note that when the users are using this
| website they are sending the attachment from their
| respective  windows... We will not consider anybody to
| copy their files in our server for sending as an
| attachment.
|
| Thanks in advance
| -Swapna
|


Can't help you on the html document / database problem, but sendmail
will pass attachments without a problem in it's standard configuration.
It can be recompiled and make use of external milters to convert html to
plain text, filter spam, scan for viruses, etc. I don't think sendmail
is even part of the issue here. I'll digress to those more experienced
in this, but first we need to know what database you're using, and does
this entry require the appropriate permissions to add, delete, insert,
drop, etc, within the database? Is your ODBC connector establishing a
socket with the database? Do you have any iptables or ipchains rules
blocking the connection? The fact that you can do an insert seems to
negate these. I suspect it may have to do with the cut & paste adding or
changing the format, white spaces, etc., and your database won't allow
certain embedded control characters.
Just a thought before I've had my coffee.
- --
Andrew Mathews
- ---------------------------------------------------------------------
~  9:26am  up 12:14, 12 users,  load average: 1.07, 1.21, 1.21
- ---------------------------------------------------------------------
You k'n hide de fier, but w'at you gwine do wid de smoke?
		-- Joel Chandler Harris, proverbs of Uncle Remus
- --
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org

iD8DBQE+0OSuidHQ0m/kEssRAhefAJ9XkBlgdLlWkuiCWi0c/43MM3+IowCfZ58/
SaFGA0Yz3Ra5ZKnLUaKmtEU=
=+qew
-----END PGP SIGNATURE-----