Recent content by spperl

Hi, Thanks for your reply and taking the time to do this. I did end up coding manually. So thanks again!

Hi, I'm work on probabilities and I'm looking for a perl module that mimics the excel POISSON(x,mean,cumulative) function where cumulative = False. The only module I have come across that is close is the Math::CDF distribution however by default the this works with cumulative probabilities...

Hi, I'm trying to create info graphics / data panels on a hobby site that I'm working on. I'm wishing to display text for one of the stat totals vertically rotated with supporting text wrapping this however I'm having difficulty getting this aligned correctly. Instead of pasting code I can...

Hi, I'm working on a game by game league table calculated by looking at football results over the last 20 years. I was wondering if anyone can help me or have some ideas where I am going wrong with the following query: select date_id, team_id, hpld hpld, htw, htd, htl, apld, atw, atd, atl...

Hi, I have a table called 'results' which is made up of the following fields id team_id result (Win, Loss, Draw) I'm trying to construct a query that will show what streak a particular team is on. e.g. Team 1 has won the last 5 Team 1 has drawn the last 0 Team 1 has lost the last 0 Team 2...

Hi, I have run into a problem on IE when trying to dynamically load a form into a panel. Here is the problem I have: On page load I have a js function that loads an info panel via a jquery / AJAX request (e.g. 'panel1') to the web server. Contents within 'panel1' should load and on selection...

Hi, I have run into a problem on IE when trying to dynamically load a form into a panel. Here is the problem I have: On page load I have a js function that loads an info panel via a jquery / AJAX request (e.g. 'panel1') to the web server. Contents within 'panel1' should load and on selection...

Just an update if anyone was wondering: Spreadsheet::ParseExcel::SaveParser allows existing xls files to be edited.

Hi, I have an xls template file that I need to append to (i.e. the headers style etc... must be maintained). Is Spreadsheet::WriteExcel appropriate for this task or does this simply create a new spreadsheet each time. If not does anyone know of any other nice modules? Any input is greatly...

OK just figured this out ... 'thinking aloud' seems to help! select * from items where to_char(price,'99999.99') ~ '5$'; works well.

Hi, Thanks for the fast reply, you are correct my pseudo code ended up just being the query that I'm running! Whilst the query may work for char columns I'm having difficulty running the above on a numeric(7,2) field. I receive the following: HINT: No operator matches the given name and...

Hi, Is there anyway I can write a query to return results only when the value of a numeric type ends in 5? Pseudo code: select * from items where price ~ '5$'; Is there a way to use regexp_matches or does price need to be cast as a string or text? Any help appreciated.

Great shout regarding Availability! Having iterated over a few examples I can easily parse the availability string to determine if in stock or not. Nice one, thank you and have a star!

Hi, Just wondering if anyone knows of a way to return the amazon stock quantity of a given product using Net::Amazon e.g. my $response = $ua->search(<<an ean>>) for ($response->properties()) { $_->ThirdPartyNewCount(); # returns the total new count for all resellers however this does...

I'm struggling with a character encoding issue. Basically the text I am trying to manipulate contains extended ascii characters which are invalid with the database encoding (unfortunately I have no control over this) Without applying a brute force search and replace does anyone know of any neat...