Recent content by rab54

Does the script run ok from the cmd line ?

Hi gurus - OK This works - sample - $sheet1->write(8, 0, '=IF(A5>3,"Yes", "No")'); What I need is this - $sheet1->write("$i", 3, '=(100/C$i) )*B$i/100', $format1); $i is the row count - I am strugging with the '100/C$i' section - I need to get the value of the 2nd/3rd $i's - I have...

sorted - I needed the quotes in the final $message - $sms->verbose( 1 ); $sms->message( "$recs records imported" ); cheers all

No worries Paul - it's a doddle - go to o2.co.uk create a user name (and password) Use the above the in the code sample above - You get 30 free - then you gotta pay - but you can do it via your phone (£1.50 per 30) not too bad ..... Still working on the variable prob .... chers

Cheers Mike - On windows (with Activestate perl) it is wperl.exe - Works like a dream cheers Rab

Cheers Mike I have already tried this tho ;~( ....

Gurus - I have a script that polls a db every minute on the server - is there a way to stop the dos box 'popping up' every time it runs ? cheers Rab

Hi gurus - I have set up a script to send me SMS Alerts on completion of variouys tasks - it all works fine except when I include variable - eg '$recs were imported' Here is a code snippet - my $sms = Net::SMS::O2->new( autotruncate => 1, username => 'myname'...

This script runs fine on my machine (Win2k Adv Server,Activestate 5.6 etc) It may be a problem with the IIS set-up - If I look at my file-types and edit the .pl entry and go to advanced I have this "C:\perl\bin\perl.exe" "%1" %* I also have this setting locally - hope this helps ! Rab

Hi gurus - What is the best way to put a unique index on a column that already has duplicate data in ? Should I remove the dupes first ? then add the index or is there a better way .... Maybe dump the table ,remove dupes with DISTINCT and re-import ? cheers Rab

By default - Port - 3306 HTH Rab

Just a thought - you will need either D:\\Windows or D:/Windows in your option file on a Windoze system ..... Hope this helps ... Rab

Cheers Paul - I have just familiarised myself a bit more with Text::CSV - you are right I think I am sorted - re the quotes - I am stripping this out first anyway .... cheers mate Rab

Hi gurus - OK I have data coming in,in this format "forename","surname","address_1","address_2","address_3" etc I have been splitting on the commas - no problem Except there are now addresses that have extar commas in the first field - eg "54,test street","address_2", etc I have got...

Genius ! Thank you kind sir - have a star ! cheers Rab