Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread walt

Keith Burke [Experience IT] wrote:

 Greetings,

 I'm new to this list but not to MySQL. I've been using MySQL on
 Linux with PHP for the past year or two. I've always managed to sort out
 any problems by looking at the documentation on the website but my
 current problem has me perplexed.

 I need to be able to send Emails to people from MySQL command
 line.

 I'm importing a text file of users via a cronjob. MySQL process
 the data and segragates it into different tables. My problem is that I
 want MySQL to Email the plain text passwords to the users before it
 MD5's them. I cannot find any references that MySQL can run external
 programs [sendmail].

 Any help or workarounds [no matter how crazy ;-)] would be appriciated,
 although I'd rather not do the Emailing and MD5'ing at the data source.

 Oh, if this isn't the correct mailing list to post this, just let me
 know.

 Regards

 **
 *   K   e   i   t   h   B   u   r   k   e*
 **
 * Experience IT Ltd   * Phone : +353 1 460 3880  *
 * G6  * GSM   : +353 86 600 4004 *
 * Riverview Business Park * Email : [EMAIL PROTECTED] *
 * New Nangor Road * WWW   : http://www.experience.ie *
 * Dublin 12   
 * Ireland *   R   a   n   g   e   R  *
 **
 *   Lieutenant, Your men are already dead*
 **

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Keith,
When you say Emailing and MD5'ing at the data source.. Are you saying you dont
want to use PHP to insert and email the passwords?

walt


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gerald Clark

Write it in perl.
Perl has modules for MySQl and Email.


Keith Burke [Experience IT] wrote:

Greetings,

   I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on the website but my
current problem has me perplexed.


   I need to be able to send Emails to people from MySQL command
line.


   I'm importing a text file of users via a cronjob. MySQL process
the data and segragates it into different tables. My problem is that I
want MySQL to Email the plain text passwords to the users before it
MD5's them. I cannot find any references that MySQL can run external
programs [sendmail].

Any help or workarounds [no matter how crazy ;-)] would be appriciated,
although I'd rather not do the Emailing and MD5'ing at the data source.

Oh, if this isn't the correct mailing list to post this, just let me
know.





Regards

**
*   K   e   i   t   h   B   u   r   k   e*
**
* Experience IT Ltd   * Phone : +353 1 460 3880  *
* G6  * GSM   : +353 86 600 4004 *
* Riverview Business Park * Email : [EMAIL PROTECTED] *
* New Nangor Road * WWW   : http://www.experience.ie *
* Dublin 12   
* Ireland *   R   a   n   g   e   R  *
**
*   Lieutenant, Your men are already dead*
**




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea

Hi,

I think youd should make an UDF which that execute in shell what you need.

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Keith Burke [Experience IT] [EMAIL PROTECTED]
To: MySQL Mailing List [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 1:23 PM
Subject: [MySQL] HELP: Can MySQL run external programs... Sendmail for
example


 Greetings,

 I'm new to this list but not to MySQL. I've been using MySQL on
 Linux with PHP for the past year or two. I've always managed to sort out
 any problems by looking at the documentation on the website but my
 current problem has me perplexed.


 I need to be able to send Emails to people from MySQL command
 line.


 I'm importing a text file of users via a cronjob. MySQL process
 the data and segragates it into different tables. My problem is that I
 want MySQL to Email the plain text passwords to the users before it
 MD5's them. I cannot find any references that MySQL can run external
 programs [sendmail].

 Any help or workarounds [no matter how crazy ;-)] would be appriciated,
 although I'd rather not do the Emailing and MD5'ing at the data source.

 Oh, if this isn't the correct mailing list to post this, just let me
 know.





 Regards

 **
 *   K   e   i   t   h   B   u   r   k   e*
 **
 * Experience IT Ltd   * Phone : +353 1 460 3880  *
 * G6  * GSM   : +353 86 600 4004 *
 * Riverview Business Park * Email : [EMAIL PROTECTED] *
 * New Nangor Road * WWW   : http://www.experience.ie *
 * Dublin 12   
 * Ireland *   R   a   n   g   e   R  *
 **
 *   Lieutenant, Your men are already dead*
 **




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Ralf Narozny

Hello!

walt wrote:

Keith Burke [Experience IT] wrote:

  

Greetings,

I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on the website but my
current problem has me perplexed.

I need to be able to send Emails to people from MySQL command
line.

I'm importing a text file of users via a cronjob. MySQL process
the data and segragates it into different tables. My problem is that I
want MySQL to Email the plain text passwords to the users before it
MD5's them. I cannot find any references that MySQL can run external
programs [sendmail].



You do it with a cronjob, so why not using some of the nice Unix 
commands on the file before importing it. I use bash or awk for such 
things...maybe like this

(Assuming your file (the_file) looks like this: USERNAME PASSWORD ...

Write an awk script, like this (mailsend)

#
#!/bin/awk -f

{
message( $1, $2 )
}

function message( uid, pwd ) {
print Dear  uid ! /tmp/mail.txt;
print  /tmp/mail.txt;
print Your username is: uid /tmp/mail.txt;
print Your password is: pwd /tmp/mail.txt;
print  /tmp/mail.txt;
print Be aware that your password will be saved in an encrypted 
format, so noone can read it! /tmp/mail.txt;
close( /tmp/mail.txt);

cmd = cat /tmp/mail.txt | mail -s 'Your password for xyz'  uid 
@somewhere.com;
system(cmd);

}

#

chmod mailsend 700

mailsend the_file

(BTW: in the above example might be syntax error, because I did not test 
it ;-) )

Greetings
 Ralf

-- 
Ralf Narozny

Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten-
management oder das komplette Office ins Portal einbinden?
Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen
Halle 3, Stand 3255

SPLENDID Internet GmbH  Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]

Walt,

Sorry, let me explain in a little more detail.

I have an Access front end ODBC'd to a Foxpro database [I hate
Foxpro :-p No choice, another company developed it for our customer.] on
a Windows server. I get it to export the data to couple of files, tar,
gzip, then ftp to my Internet server.

I don't want to have to MD5 at this stage, it's so much
easier to do it on the linux box. Emailing is not a problem on the
Windows box.

Will eventually go to VB scheduled job, or let Oracle handle the
whole source data thing.

Hope that clears it up a bit for ye ;-)





Regards

**
*   K   e   i   t   h   B   u   r   k   e*
**
* Experience IT Ltd   * Phone : +353 1 xxx xxx  *
* Unit G6 * GSM   : +353 86 xxx xxx *
* Riverview Business Park * Email : [EMAIL PROTECTED] *
* New Nangor Road * WWW   : http://www.experience.ie *
* Dublin 12   *  *
* Ireland *  *
**


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of walt
Sent: 06 September 2002 15:05
To: [EMAIL PROTECTED]
Cc: MySQL Mailing List
Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail
for example


*snip*

Keith,
When you say Emailing and MD5'ing at the data source.. Are you saying
you dont want to use PHP to insert and email the passwords?

walt


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea

...or a good alternative is PAGER.

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; MySQL Mailing List [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 5:10 PM
Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for
example


 Hi,

 I think youd should make an UDF which that execute in shell what you need.

 Regards,

 Gelu
 _
 G.NET SOFTWARE COMPANY

 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Keith Burke [Experience IT] [EMAIL PROTECTED]
 To: MySQL Mailing List [EMAIL PROTECTED]
 Sent: Friday, September 06, 2002 1:23 PM
 Subject: [MySQL] HELP: Can MySQL run external programs... Sendmail for
 example


  Greetings,
 
  I'm new to this list but not to MySQL. I've been using MySQL on
  Linux with PHP for the past year or two. I've always managed to sort out
  any problems by looking at the documentation on the website but my
  current problem has me perplexed.
 
 
  I need to be able to send Emails to people from MySQL command
  line.
 
 
  I'm importing a text file of users via a cronjob. MySQL process
  the data and segragates it into different tables. My problem is that I
  want MySQL to Email the plain text passwords to the users before it
  MD5's them. I cannot find any references that MySQL can run external
  programs [sendmail].
 
  Any help or workarounds [no matter how crazy ;-)] would be appriciated,
  although I'd rather not do the Emailing and MD5'ing at the data source.
 
  Oh, if this isn't the correct mailing list to post this, just let me
  know.
 
 
 
 
 
  Regards
 
  **
  *   K   e   i   t   h   B   u   r   k   e*
  **
  * Experience IT Ltd   * Phone : +353 1 460 3880  *
  * G6  * GSM   : +353 86 600 4004 *
  * Riverview Business Park * Email : [EMAIL PROTECTED] *
  * New Nangor Road * WWW   : http://www.experience.ie *
  * Dublin 12   
  * Ireland *   R   a   n   g   e   R  *
  **
  *   Lieutenant, Your men are already dead*
  **
 
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]


Michael T. Babcock wrote:

May I rephrase your comment?

I need to send E-mails to people from MySQL data.

I recommend just doing a SELECT on the data in question and generating
the E-mails from PERL or PHP or whatever other language you are using.




No you may not ;-)
*joke*

It needs to be run automatically without user intervention [cronjob] so
the PERL [not an option as I've never used it]  or PHP would have to be
of the CGI variety [if that's what you call the standalone version, not
the API for the web server].

But it is an option and I'll consider.

I'll probably try the suggestion by Ralf Narozny first.
It seems to be exactly what I want, plus... It's relatively simple :-)

I'll also have to read up on those UDF's. Sounds interesting.


Cheers everyone.

Regards

**
*   K   e   i   t   h   B   u   r   k   e*
**
* Experience IT Ltd   * Phone : +353 1 xxx   *
* Unit G6 * GSM   : +353 86 xxx  *
* Riverview Business Park * Email : [EMAIL PROTECTED] *
* New Nangor Road * WWW   : http://www.experience.ie *
* Dublin 12   *  *
* Ireland *  *
**


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea


...
 I'll also have to read up on those UDF's. Sounds interesting.
...or PAGER.
Try to do a test:

\P mail root@localhost;
select User,Host,Password from mysql.user;
\n

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Keith Burke [Experience IT] [EMAIL PROTECTED]
To: 'Michael T. Babcock' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 06, 2002 6:00 PM
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for
example



 Michael T. Babcock wrote:

 May I rephrase your comment?
 
 I need to send E-mails to people from MySQL data.
 
 I recommend just doing a SELECT on the data in question and generating
 the E-mails from PERL or PHP or whatever other language you are using.




 No you may not ;-)
 *joke*

 It needs to be run automatically without user intervention [cronjob] so
 the PERL [not an option as I've never used it]  or PHP would have to be
 of the CGI variety [if that's what you call the standalone version, not
 the API for the web server].

 But it is an option and I'll consider.

 I'll probably try the suggestion by Ralf Narozny first.
 It seems to be exactly what I want, plus... It's relatively simple :-)

 I'll also have to read up on those UDF's. Sounds interesting.


 Cheers everyone.

 Regards

 **
 *   K   e   i   t   h   B   u   r   k   e*
 **
 * Experience IT Ltd   * Phone : +353 1 xxx   *
 * Unit G6 * GSM   : +353 86 xxx  *
 * Riverview Business Park * Email : [EMAIL PROTECTED] *
 * New Nangor Road * WWW   : http://www.experience.ie *
 * Dublin 12   *  *
 * Ireland *  *
 **


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Keith Burke [Experience IT]

Sorry, my bad.

What is this PAGER and where do I run your test script from?





Regards

**
*   K   e   i   t   h   B   u   r   k   e*
**
* Experience IT Ltd   * Phone : +353 1 460 3880  *
* Unit G6 * GSM   : +353 86 600 4004 *
* Riverview Business Park * Email : [EMAIL PROTECTED] *
* New Nangor Road * WWW   : http://www.experience.ie *
* Dublin 12   *  *
* Ireland *  *
**


-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] 
Sent: 06 September 2002 16:39
To: [EMAIL PROTECTED]; 'Michael T. Babcock'; [EMAIL PROTECTED]
Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail
for example



...
 I'll also have to read up on those UDF's. Sounds interesting.
...or PAGER.
Try to do a test:

\P mail root@localhost;
select User,Host,Password from mysql.user;
\n

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Keith Burke [Experience IT] [EMAIL PROTECTED]
To: 'Michael T. Babcock' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 06, 2002 6:00 PM
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail
for example



 Michael T. Babcock wrote:

 May I rephrase your comment?
 
 I need to send E-mails to people from MySQL data.
 
 I recommend just doing a SELECT on the data in question and 
 generating the E-mails from PERL or PHP or whatever other language 
 you are using.




 No you may not ;-)
 *joke*

 It needs to be run automatically without user intervention [cronjob] 
 so the PERL [not an option as I've never used it]  or PHP would have 
 to be of the CGI variety [if that's what you call the standalone 
 version, not the API for the web server].

 But it is an option and I'll consider.

 I'll probably try the suggestion by Ralf Narozny first.
 It seems to be exactly what I want, plus... It's relatively simple :-)

 I'll also have to read up on those UDF's. Sounds interesting.


 Cheers everyone.

 Regards

 **
 *   K   e   i   t   h   B   u   r   k   e*
 **
 * Experience IT Ltd   * Phone : +353 1 xxx   *
 * Unit G6 * GSM   : +353 86 xxx  *
 * Riverview Business Park * Email : [EMAIL PROTECTED] *
 * New Nangor Road * WWW   : http://www.experience.ie *
 * Dublin 12   *  *
 * Ireland *  *
 **


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Gelu Gogancea

Hi Keith,
It's very simple.
type from console : mysql -u root -h your_hostor whatever you need to
start mysql client and after this just type :

mysql\P mail root@localhost;
mysqlselect User,Host,Password from mysql.user;
mysql\n;

...after this you can look in the root e-mail box and you can see the result
of query.
Indeed doesn't work with ENCAPSULATED(i don't  know a better term in
english...Ufff my english) SQL QUERY
If this solution it's not what you need the alternative is UDF.
Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Keith Burke [Experience IT] [EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; 'Michael T. Babcock'
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 6:54 PM
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for
example


 Sorry, my bad.

 What is this PAGER and where do I run your test script from?





 Regards

 **
 *   K   e   i   t   h   B   u   r   k   e*
 **
 * Experience IT Ltd   * Phone : +353 1 460 3880  *
 * Unit G6 * GSM   : +353 86 600 4004 *
 * Riverview Business Park * Email : [EMAIL PROTECTED] *
 * New Nangor Road * WWW   : http://www.experience.ie *
 * Dublin 12   *  *
 * Ireland *  *
 **


 -Original Message-
 From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
 Sent: 06 September 2002 16:39
 To: [EMAIL PROTECTED]; 'Michael T. Babcock'; [EMAIL PROTECTED]
 Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail
 for example



 ...
  I'll also have to read up on those UDF's. Sounds interesting.
 ...or PAGER.
 Try to do a test:

 \P mail root@localhost;
 select User,Host,Password from mysql.user;
 \n

 Regards,

 Gelu
 _
 G.NET SOFTWARE COMPANY

 Permanent e-mail address : [EMAIL PROTECTED]
   [EMAIL PROTECTED]
 - Original Message -
 From: Keith Burke [Experience IT] [EMAIL PROTECTED]
 To: 'Michael T. Babcock' [EMAIL PROTECTED];
 [EMAIL PROTECTED]
 Sent: Friday, September 06, 2002 6:00 PM
 Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail
 for example


 
  Michael T. Babcock wrote:
 
  May I rephrase your comment?
  
  I need to send E-mails to people from MySQL data.
  
  I recommend just doing a SELECT on the data in question and
  generating the E-mails from PERL or PHP or whatever other language
  you are using.
 
 
 
 
  No you may not ;-)
  *joke*
 
  It needs to be run automatically without user intervention [cronjob]
  so the PERL [not an option as I've never used it]  or PHP would have
  to be of the CGI variety [if that's what you call the standalone
  version, not the API for the web server].
 
  But it is an option and I'll consider.
 
  I'll probably try the suggestion by Ralf Narozny first.
  It seems to be exactly what I want, plus... It's relatively simple :-)
 
  I'll also have to read up on those UDF's. Sounds interesting.
 
 
  Cheers everyone.
 
  Regards
 
  **
  *   K   e   i   t   h   B   u   r   k   e*
  **
  * Experience IT Ltd   * Phone : +353 1 xxx   *
  * Unit G6 * GSM   : +353 86 xxx  *
  * Riverview Business Park * Email : [EMAIL PROTECTED] *
  * New Nangor Road * WWW   : http://www.experience.ie *
  * Dublin 12   *  *
  * Ireland *  *
  **
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting

Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

2002-09-06 Thread Ed Carp

Might want to look at writing either a shell script or doing it in C, if it
has to be non-interactive.  Escapade can also do thos sort of thing
interactively, and it's as simple as 4 lines of code.
- Original Message -
From: Keith Burke [Experience IT] [EMAIL PROTECTED]
To: 'Michael T. Babcock' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 06, 2002 10:00 AM
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for
example



 Michael T. Babcock wrote:

 May I rephrase your comment?
 
 I need to send E-mails to people from MySQL data.
 
 I recommend just doing a SELECT on the data in question and generating
 the E-mails from PERL or PHP or whatever other language you are using.




 No you may not ;-)
 *joke*

 It needs to be run automatically without user intervention [cronjob] so
 the PERL [not an option as I've never used it]  or PHP would have to be
 of the CGI variety [if that's what you call the standalone version, not
 the API for the web server].

 But it is an option and I'll consider.

 I'll probably try the suggestion by Ralf Narozny first.
 It seems to be exactly what I want, plus... It's relatively simple :-)

 I'll also have to read up on those UDF's. Sounds interesting.


 Cheers everyone.

 Regards

 **
 *   K   e   i   t   h   B   u   r   k   e*
 **
 * Experience IT Ltd   * Phone : +353 1 xxx   *
 * Unit G6 * GSM   : +353 86 xxx  *
 * Riverview Business Park * Email : [EMAIL PROTECTED] *
 * New Nangor Road * WWW   : http://www.experience.ie *
 * Dublin 12   *  *
 * Ireland *  *
 **


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php