Connect MySQL with Majordomo in a Perl Script?

2002-05-31 Thread Miretsky, Anya
Hi, Can anyone point me to some documentation or examples of how to write a Perl script that will get a list of email addresses from a mysql database and use Majordomo to send an email to all of them? I've written scripts before that get data from mysql but have no clue how to connect this to M

RE: Help with my first package??

2002-05-16 Thread Miretsky, Anya
06:22 , Miretsky, Anya wrote: > I've tried both now and I still get the error "can't locate DBI.pm in > @INC.." I've used the DBI module successfully in my other cgi pages so > I can't understand why its not being found here??? That sounds like:

RE: Help with my first package??

2002-05-16 Thread Miretsky, Anya
Sent: Wednesday, May 15, 2002 5:33 PM To: Miretsky, Anya Subject: RE: Help with my first package?? Anya, my ($dsn) = "DBI:mysql:getgreen:localhost"; _might_ be problematic try my ($dsn) = "dbi:mysql:dbname=getgreen;host=localhost;"; ^^^^^^

Help with my first package??

2002-05-15 Thread Miretsky, Anya
I am trying to write a package that will execute a sql statement for me in my cgi pages, the following is the code for the package, but when I run it at the command prompt I get error messages about the first line where I set the $dsn. I think the problem is with the use of DBI. The sql that I pa

Regulare Expressions/ Substitution Question

2001-11-15 Thread Miretsky, Anya
I am trying to replace all occurences of the word St with St. without generating St.. in the incorrect substitutions of St. The code I have been playing with is something like: $item = "35 Main St." (it could also be "35 Main St" in which case I want the substitution to happen) $varS = "st"; $