RE: get full month name

2007-12-09 Thread Jo for Groups and Lists
Can you use Date::Manip ? $fullMonth = &returnFullmonth($month); sub returnFullmonth { use Date::Manip; return UnixDate("2007/$_/01",'%B'); } This will handle feb, 02, or 2 but will not handle february itself - so you may want to check first that you are indeed passing in 1-2

Conditions and actions in an external chart ?

2007-11-20 Thread Jo for Groups and Lists
Is there a way to store and retrieve code for conditions and actions in a chart? Something like Condition action $Pet eq "dog" $suggest.="Buy a Bone?" $numBiscuits >1 $subTotal+=($numBiscuits*2.00) ($cond,$act)=split(/\t/); if ($cond) { $act; } I haven't a clue what I need to lo

RE: :mysql::st execute failed: Column count doesn't match value count at row 1 a

2007-11-16 Thread Jo for Groups and Lists
After viewing this again IN PLAIN TEXT You have an unmatched double quote here. AND an unmatched single quote AND a backtick. No wonder it's not behaving as expected. Would have been easier to spot without that stationary. Jo -Original Message- From: Jo for Groups and

RE: :mysql::st execute failed: Column count doesn't match value count at row 1 a

2007-11-16 Thread Jo for Groups and Lists
my $sql="insert into $table values ('2345','4355','834','894,'766'); You have an unmatched double quote here. Jo <>

RE: outlook module

2007-11-01 Thread Jo for Groups and Lists
It seems to me that your network admins need to correct their faulty procmail routing recipes. It should not be your job to deal with this. Do the network admins have any idea how big a problem this is? Not only for your inconvenience, but for the other person not receiving messages? Jo -- To u

How to prevent split from returning blanks

2007-10-28 Thread Jo for Groups and Lists
What I want are these array members from a string in a database. I'm almost there, just need to strip off the trailing pipe, but I am getting empty members too, so will have to test for that and dump the empty ones before proceeding. Is this the best solution? {No, we can't change the database form