Re: use strict - config file?

ckage (thanks to you), do I also need to set up my subroutines file as a package? If so, do I have to explicitly export all the possible return variables in the whole subroutines package? thanks again! Rory On Thu, 2002-07-11 at 13:59, Peter Scott wrote: > At 01:19 PM 7/11/02 -0500, rory oconn

Re: use strict - config file?

Peter, Thanks so much for the help! Unfortunately I am not using 5.6. I'd like to, but it's not up to me to do the upgrading! Which parts are 5.6-only, and how can I work around? Thanks, Rory On Thu, 2002-07-11 at 13:09, Peter Scott wrote: > At 12:27 PM 7/11/02 -0500, rory

use strict - config file?

I want to "use strict" in a script I'm writing. I have a separate config file I am using (require "config.pl";) with a bunch of global variables. But my script doesn't seem to want to recognize those variables unless they are actually declared in the body of the script itself. I tried using "my

passing hash to a subroutine

Is it possible to pass a hash into a subroutine to be used as a local variable? I'm trying to do this: ($rows, %results) = &Select($mytable, $where_f1, $compare1, $where_v1, @quick_check, %field_values); sub Select { my($db_table, $where_field, $comparison, $where_value,@fieldlist, %values) = @

e-mailing with DBI

I manage my mailing lists (yes, the are opt-in) in mysql and operate on it with perl. However, the missing piece right now is the mailing execution element. I'd like to create a perl script that will mail each one of my receipients a personalized message. I can create and send the message, but

RE: MIME::Lite trouble

s are http). Is there a way to use that module to just slurp in a local html file w/o images? Thanks, Rory On Thu, 2002-05-23 at 11:22, Bob Showalter wrote: > > -Original Message- > > From: rory oconnor [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, May 23, 2002 9:18 AM &g

MIME::Lite trouble

I did take a listmember's suggestion and tried out MIME::Lite for including a html attachment in an email. Unfortunately it's not doing what I'd like it to. I'm trying to get a perl script to slurp in a ..html file and e-mail it as HTML mail, just as you'd receive from buy.com, amazon.com, etc.

html mails

I send out html (opt-in) marketing emails regularly, and I would like to create a script that allows people to enter a friend's address to have the e-mail sent to them (one-time only). I was thinking of including a small text-entry form in the e-mail for people to enter a friend's email address,

perl DBI disconnect question

Regarding perl DBI - I know it's proper to use $sth->finish and $dbh->disconnect and I am doing that at the end of my script... however, i am also doing alot of error checking at the beginning of the script (to make sure data has been entered, and formatted properly). If there's an error I woul

dynamic variable declaration?

I'm trying to do something that i'm not sure is even possible. I want to cycle thru an array of MySQL fieldnames and dynamically declare variables based on those fieldnames. I can create the array of fieldnames no problem, by just using "describe" with DBI. But I can't figure out the declarati

stripping out quotes

I get a file of email addresses that is tab-delimited that i import into a mysql database. occasionally there is an email address enclosed in quotes that really mucks things up. How can I handle this? thanks! Rory -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

Re: Password Encryption for MySQL field

sword ) FROM user WHERE username='someuser' AND > password=password( 'plaintextpass' ); > > Regards, > Luke Davison > > - Original Message - > From: "rory oconnor" <[EMAIL PROTECTED]> > To: "perl" <[EMAIL PROTECTED]&

Password Encryption for MySQL field

I'm writing a small perl script that will help web users manage an "account" (i.e. their record in a mysql table). I want to store their password in a field, but I don't want to store it in regular text. I'm not sure if this is a perl or MySQL function, but I think there is some method of "encry

DBI results help

I'm trying to write some queries to export MySQL information to a file, and I'm a bit of a newbie. I'm querying the database for fieldnames, and then field data. then I want to write the data to a file in a sort of key:value format: [fieldname]:[field data] for example... SKUID:AF332 NAME:Jes

bounceback filter script

I wonder if anyone on this list might have a perl script that accesses a POP mailbox and culls out bounceback-type emails? I need something that i can run locally to connect to a remote box and filter messages based on typical bounceback criteria ("Undeliverable", "Mail Error", etc) and write the

listing date ranges

I am writing a perl front-end to create dynamic queries on a mysql database, and i'm a pretty new programmer! I want to offer the user a date range, and the dates I want to use are stored in records in my database: 2002-02-17 2002-02-24 2002-03-02 2002-03-09 2002-03-15 and I kow how to s

Re: Finding the date of last sunday

Jeff, One quick question...since I want to run this every week, will that part here you hard-coded today's date need to be changed to be dynamic? thanks, rory On Wed, 2002-03-20 at 22:30, Jeff 'japhy' Pinyan wrote: > On Mar 20, rory oconnor said: > > >Can anyone th

Finding the date of last sunday

Can anyone think of a good way for me to find out what the date of last sunday is with perl? I'm writing a script that will need to do some basic reporting starting from the previous sunday. I'm usign the date format -MM-DD Any help appreciated! Thanks, rory -- To unsubscribe, e-mail:

regex question

I am using LWP to hit a page and save the source to a file. But before it saves it I want it to strip out the client id from the urls. They are always in the same format: client=& # 8 digits and then ampersand so what I want to strip out is stuff like: client=23894749& i am a newbie

saving source of a page to a file

I'm not sure if perl's the right weapon for this, but I bet it is. I need to save the source of a webpage to a file. Can anyone think of a good way to do that? I'm using my commerce application to create a webpage using a template and query string parameter data...and the final rendered page is

Adding/deleting a file

I need to touch a file with a "1" in it if a condition is true, and either toggle the "1" to a "0" or delete the file (whichever is better, probably toggle) if another condition is true. Excuse my newbie-ness...but can anyone give me some hints as to the correct syntax for that? thanks, rory