08-07-2008
This served the purpose but not completely...
Because I want to send an HTML message with attached file and it shoud have a body...
I m trying the following code but its not working:
uuencode ${CSV_FILE1} ${CSV_NAME1} | (
echo "From:${SENDER_ADDRESS}"
echo "To: ${EMAIL_RECIPIENTS}"
echo "MIME-Version: 1.0"
echo "Content-Type: multipart/mixed;"
echo ' boundary="PAA08673.1018277622/server.domain.com"'
echo "Subject: Test Message"
echo ""
echo "This is a MIME-encapsulated message"
echo ""
echo "--PAA08673.1018277622/server.domain.com"
echo "Content-Type: text/html"
echo ""
echo "<HTML>
<BODY bgcolor=white>
<blockquote><font color=black>Please find the attached report.</font> <font co
lor=blue>Message by me</font> <font
color=blue>Body</font></blockquote>
</body>
</html>"
echo "--PAA08673.1018277622/server.domain.com"
) | mailx -t
It only sends the html mail but without any attachment.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a KSH script that runs a SQL script, then sends an email to me indicating that it's completed. I would like to modify it so that the body of the email will contain a count of the number of records Added, Changed, Deleted as a result of the SQL script.
Here's what I was trying, but it's... (2 Replies)
Discussion started by: dstinsman
2 Replies
2. UNIX for Dummies Questions & Answers
Hi
I am totally dummy as far as UNIX is concerned, so please apologize.
I was just given the syntax to send multiple attachments with a body.txt message, it works great and we use it a lot.
Now, my question is : can we have the body to be a Binary file (like a Word Document for example)?
... (5 Replies)
Discussion started by: CKIRCH
5 Replies
3. AIX
Hi,
How can I send mail attachments from shell script (AIX) and have a mail body as well ?
Thanks in advance. (1 Reply)
Discussion started by: shibajighosh
1 Replies
4. UNIX for Advanced & Expert Users
display HTML text in body using unix mailX ????Hello,
could any one tell me how to display text in html layout by sending a file using mailx command in unix.
i know to use mailx :
mailx -s "SUBJECT" user.name@domail.com < file_name.txt
instead of txt file i want to send html page and... (8 Replies)
Discussion started by: sparan_peddu
8 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I'm working on Solaris 9 (SPARC) and I like to send an html body message to our users when something happen.
The problem is that I can't find how to give mime type information with mailx.
To be recognized as html I need to put in email header this information:
Mime-Version: 1.0... (2 Replies)
Discussion started by: gbagagli
2 Replies
6. Shell Programming and Scripting
Hi,
Our requirement is to send an attachment and content in a single mail. I am using the below command to send attachement.
---------------------
(uuencode $exp_file $exp_file) |mailx -s "$email_subject" $EmailRecipients
--------------------
I m not able to send any message in the... (4 Replies)
Discussion started by: ashwin3086
4 Replies
7. UNIX for Dummies Questions & Answers
Hi,
Is there a way to suppress this message?
Null message body; hope that's ok
My email string is:
mailx -s "This is my subject" myemail@domain.com < /dev/null
It's just an annoyance to me that I would like see go away. (3 Replies)
Discussion started by: bbbngowc
3 Replies
8. Shell Programming and Scripting
Hi,
I am using mailx command to send an email and i took the body of the email from a file,
mailx -r gtt.org -s "Status Report " ss@org.com < $ProcessStatisticsFile
but now i want to declare the body of the email in the command itself.
I have tried with the following command but... (4 Replies)
Discussion started by: chinnu01
4 Replies
9. Shell Programming and Scripting
Hi,
I'm a perl developer. I need to attach a file from my perl cgi script and send mail to our users whoever using our website. I have used mailx command to attach a file.. it is working fine for me. The problem I'm facing is I'm not getting body of the mail.
I have a function called... (0 Replies)
Discussion started by: bheeshmaraja
0 Replies
10. Shell Programming and Scripting
i have to attach the 'body in the email' along with attachment below code is throwing errors, how can i do it ?
here body file contains message, it should display in email, please help
i am using HP-UX
(cat body ;) (uuencode attch1 attch1 ;) | mailx -m -s "testing" "abc@gmail.com"
... (4 Replies)
Discussion started by: only4satish
4 Replies
LEARN ABOUT PHP
oci_field_type
OCI_FIELD_TYPE(3) OCI_FIELD_TYPE(3)
oci_field_type - Returns a field's data type name
SYNOPSIS
mixed oci_field_type (resource $statement, mixed $field)
DESCRIPTION
Returns a field's data type name.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the field data type as a string, or FALSE on errors.
EXAMPLES
Example #1
oci_field_type(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
$column_size = oci_field_size($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "<td>$column_size</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumntype(3) instead. This name still can be used, it was left as alias of
oci_field_type(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO
oci_num_fields(3), oci_field_name(3), oci_field_size(3).
PHP Documentation Group OCI_FIELD_TYPE(3)