From: Date: September 6 2002 5:54pm
Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
List-Archive: http://lists.mysql.com/mysql/118960
Message-Id: <00c701c255bd$a5874200$2100a8c0@EXPERIENCE.local>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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 : kburke@stripped     *
* New Nangor Road         * WWW   : http://www.experience.ie *
* Dublin 12               *                                  *
* Ireland                 *                                  *
**************************************************************


-----Original Message-----
From: Gelu Gogancea [mailto:ggelu@stripped] 
Sent: 06 September 2002 16:39
To: kburke@stripped; 'Michael T. Babcock'; mysql@stripped
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 : gg@stripped
                                          gelugogancea@stripped
----- Original Message -----
From: "Keith Burke [Experience IT]" <kburke@stripped>
To: "'Michael T. Babcock'" <mbabcock@stripped>;
<mysql@stripped>
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 xxxx          *
> * Unit G6                 * GSM   : +353 86 xxx xxxx         *
> * Riverview Business Park * Email : kburke@stripped     *
> * 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 <mysql-thread118953@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>