Re: Mysql performace 30000 record

2002-10-01 Thread Jason Purdy
This looks like a problem more for the beginners list than the fwp list. With that said, you can create several different statement handles outside of the while loop and use placeholders (one of the things I LOVE about DBI and Perl). $sthOne = $dbh->prepare( "SELECT COUNT(*) FROM lognew WHERE pa

Re: TPR1 post-mortem

2002-03-08 Thread Jason Purdy
Someone's gonna explain these, right? Man, I love learning this kinda stuff. Last "hole", I learned about pop vs. shift (saving two strokes) and after seeing this e-mail and playing around with Perl, I see that "-l" will take care of the newline stuff for me (so I don't have to add "$_\n" to

Re: substitution question

2002-01-31 Thread Jason Purdy
This will not work (the . will match the /'s and preface them with 0's)... try \d instead: $ perl -e '$a="9/9/1973\n";$a=~s/\b(.)\b/0$1/g;print $a;' 090/090/1973 $ perl -e '$a="9/9/1973\n";$a=~s/\b(\d)\b/0$1/g;print $a;' 09/09/1973 $ perl -e '$a="9/09/1973\n";$a=~s/\b(\d)\b/0$1/g;print $a;' 09/0

Re: A present ...

2002-01-24 Thread Jason Purdy
I don't have the rules with me (I'm at work now), but I thought that there has to be an even # (or 0) of each vowel separately. Is that right? So if the word was: bane it would pass this program (if it was on an even line), but not the rules since there's an odd # of a's and e's (again, as I

^=~

2002-01-20 Thread Jason Purdy
Personally, it looks like a 'fox' to me - pointy ears & bushy tail. Jason