02-02-2006
How to send Mail with Attachement
Hi
Can somebody help me in wirting shell script in the following way.Desperately i have poseted this..
1.How can I connect to Oracle(Sqlplus) from UNIX.
2.After connecting to it I have to execute an oracle proceudure..
3.Execution of the procedure will give some set of rows..
4.The set of rows have to be 'Spool' to a seperate file and that file has to be sent to particular user as attachement.
Regards
Gopinath
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear All:
I want to send a message to a list of people with a subject and an attachement, currently I am using the following command into a shell script:
uuencode $FILENAME.gz $FILENAME.gz | mail john.kennedy@mycompany.com m.m@mycompany.com
With this command I can send the message for a... (1 Reply)
Discussion started by: josecollantes
1 Replies
2. UNIX for Dummies Questions & Answers
I wanted to try sending a mail with an attachement at command prompt in unix. Some one please advise that how we can do it ?
Thanks, :) (2 Replies)
Discussion started by: gaddeg
2 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I am a newbie to unix.
I need to send an email with an attachment in unix to some id like abc@some_company.com
Code i have used is
------------Code---------------------------
#!/bin/ksh
set -x
#set -n
#cript: unix_mail_withattachments.ksh
# Aurthor: Ravin Maharaj
#... (1 Reply)
Discussion started by: samuelc
1 Replies
4. Shell Programming and Scripting
Hi all,
i am working with CSH, i want to know that
how to send a mail in UNIX shell script (CSH) with attachment as well as message body.
i know that how to send a mail with attachment and message body. but i want know both things in a single mail
Suggession would be appreciate.
... (1 Reply)
Discussion started by: psiva_arul
1 Replies
5. Shell Programming and Scripting
Hi All,
I have general query that ...in my script i used uuencode
option like below.
cd /location
(cat test.txt
uuencode test.csv test.csv ) | mail -s "test mail" "mail_id"
but whenever i run the above command its giving error like below
./testscript.sh: uuencode not found:
... (1 Reply)
Discussion started by: Shahul
1 Replies
6. UNIX for Advanced & Expert Users
I want to read attachements sent to unix mail id and save the attachement in folder.
I may receive the mails from different mail clients(outlook, lotus ..etc).
Attachements are in CSV(comma saperate) format.
Let me know the shell script code for this.
Regards,
Venkat (1 Reply)
Discussion started by: svenkatareddy
1 Replies
7. Shell Programming and Scripting
Can't attach text files to 'mail' command. I dont have mutt or mailx to use on my server. so i have to use mail command
any help would be great.
Regards,
Kiran (1 Reply)
Discussion started by: dddkiran
1 Replies
8. Shell Programming and Scripting
Hi ,
I am using the below code to send mail through a script which run as a cron job.
msgdate=`date +"%a, %e %Y %T %z"`
daemail=$(cat <<!
From: $from
To: $emailtarget
Subject: $subject
Mime-Version: 1.0
Content-Type: multipart/mixed;
Content-Disposition: inline
$priority
$CONTENT
!)... (2 Replies)
Discussion started by: ahamed
2 Replies
9. Solaris
Hello,
I am able to attache the file in UNIX/LINUX script using following code.
MAILFORMAT="Please do not replay this mail.This mail is auto generated."
echo -e $MAILFORMAT | mailx -r autoreplay@gmail.com -a filename -s "status" xyz@gmail.com
But same I am not able attache... (6 Replies)
Discussion started by: nes
6 Replies
PDO.EXEC(3) 1 PDO.EXEC(3)
PDO
::exec - Execute an SQL statement and return the number of affected rows
SYNOPSIS
public int PDO::exec (string $statement)
DESCRIPTION
PDO.exec(3) executes an SQL statement in a single function call, returning the number of rows affected by the statement.
PDO.exec(3) does not return results from a SELECT statement. For a SELECT statement that you only need to issue once during your program,
consider issuing PDO.query(3). For a statement that you need to issue multiple times, prepare a PDOStatement object with PDO.prepare(3) and
issue the statement with PDOStatement.execute(3).
PARAMETERS
o $statement
- The SQL statement to prepare and execute. Data inside the query should be properly escaped.
RETURN VALUES
PDO.exec(3) returns the number of rows that were modified or deleted by the SQL statement you issued. If no rows were affected, PDO.exec(3)
returns 0.
Warning
This function may return Boolean FALSE, but may also return a non-Boolean value which evaluates to FALSE. Please read the section on
Booleans for more information. Use the === operator for testing the return value of this function.
The following example incorrectly relies on the return value of PDO.exec(3), wherein a statement that affected 0 rows results in a call to
die(3):
<?php
$db->exec() or die(print_r($db->errorInfo(), true));
?>
EXAMPLES
Example #1
Issuing a DELETE statement
Count the number of rows deleted by a DELETE statement with no WHERE clause.
<?php
$dbh = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');
/* Delete all rows from the FRUIT table */
$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");
/* Return number of rows that were deleted */
print("Deleted $count rows.
");
?>
The above example will output:
Deleted 1 rows.
SEE ALSO
PDO.prepare(3), PDO.query(3), PDOStatement.execute(3).
PHP Documentation Group PDO.EXEC(3)