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
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
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
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
Personally, it looks like a 'fox' to me - pointy ears & bushy tail.
Jason