Search results for query: *

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...

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'...

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

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...

Hi gurus - just need a nudge in the right direction - How do I deal with joins with dbi eg SELECT t1.name,t2.address FROM t1,t2 WHERE t1.name = t2.name When I assign like this my $name = "$ref->{'name'}"; I get an empty string back .... The sql...

Guys - I am searching for an unthreaded version of perl - I have tried CPAN and others but having no joy - Any ideas welcome ... Rab

OK gurus - I need to read in a previously generated spreadsheet - and then add new data from a db - I have this so far - for(my $iSheet=0; $iSheet < $oBook->{SheetCount} ; $iSheet++) { $oWkS = $oBook->{Worksheet}[$iSheet]; for(my $iR = $oWkS->{MinRow} ; defined...

OK gurus - Is it possible to display a variable in a MessageBox ,using perl/tk ? cheers for any help Rab

Access Gurus - I hardly ever use MS Access so please bear with me ;-) We have a 3rd-party app that connects to an access db - it works fine on my local machine - However I want it to sit on the server so that a number of client machines can connect to it simultaneously (read-only) I have...

OK Gurus - This follows my earlier post - I have my executable file - within this are various programs that read and write to files on the server - My question is - if I share say the wwwroot directory out so it can be accessed from the exe file does it mean the user can map a drive to...

Hi gurus once again ;-) OK - I am using perl2exe to bundle my perl/tk app - all is fine except I need to know how I cope with images that are stored on the server - eg c:/images/test.jpg --- on the server If I use this path when I have turned it into an exe file obviously it will look for...

OK gurus - My adventure with Tk continues ;-) I am using Tk::mySplashscreen module - I can get the default logo up - but if I substitute my own I get the following - can't open image blah in mode 'r' Any ideas ? I can't find many pointers .... cheers once again .. Rab

Hi gurus - OK I have a small perl/tk gui front-end - One of the options is to run an import on a mysql database - I would like to show the user how far we have got with the insert .... I have set the ProgressBar widget up and it runs fine - but only with the default values eg - my...

Hi gurus - I have a perl proggy that runs every minute on our win2k3 server - Is there a way to stop the dos box opening on each run of the program ? cheers in advance Rab

OK Guru's what a great module this is ! Anyway how can I get the spreadsheet to be 'expanded' on being opened - eg not having to go to the top left, then double-click the column-header to expand to enable all the data to be seen Hope this makes some sense .... thanks in advance for any help...

Howdy gurus - OK I have this module up and running - What I need to do is to do a loop and write a new row in the spreadsheet on each iteration - Can anyone give me any pointers ? thanks in advance Rab

Howdy guys - OK I have our mysql db on the c: - but due to it's increasing size I have been asked to move it to the d: drive .... I am on Win2k3 so is it just a case of moving the data over or will I have to re-install mysql onto the d: drive and then move the data over - Any advice would...

Hi gurus - OK we have a new application using sybase (on a sun box) - But the application is fairly 'black-boxed' - I come from a Mysql/perl background,but how do I go about finding out the db usernames and passwords - ie is there an equivalent to the user/grant tables in mysql ? I am...

Hello again gurus - I am pulling data out and sorting on the postcode - but have been asked to put it in 'proper' order - ie non-acii-betically .. I need - BB1 BB2 BB10 BB25 NOT - BB1 BB10 BB2 BB25 Can we do this in the 'select' statement ? cheers once again guys Rab