On Mon, 8 May 2006, si-riesal wrote:
This is my 1st post to this newsgroup.
Actually.. i've tried to make this post as clean as possible, and forgive for
my bad english, iam indonesian.
okay.. this is my problem.
Iam doing my homework to send back a database query result via e-mail using
procmail. The database that i used is MySQL 5.0.16 running on FreeBSD 5.4 and
procmail 3.22.
The 1st code should be like this:
--.procmailrc file--
MAILDIR=$HOME/mail
LOGFILE=$HOME/mail/log
:0
* ^Subject: getresult stuid \/[^ ]*
| echo "USE TEST; SELECT student_id FROM TEST WHERE student_id=$MATCH" | /usr/
local/mysql/bin/mysql -t > $HOME/mail/result.txt | formail -rA "X-Loop:
I think that you didn't check this pipe before. You have
error: command > result | command
^^^ ^^^
Where do want to direct the stdout?
,,
Udi
____________________________________________________________
procmail mailing list Procmail homepage: http://www.procmail.org/
procmail(_at_)lists(_dot_)RWTH-Aachen(_dot_)DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail