Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by spperl
-
inverse poisson using perl (Math::CDF)
Hi, Thanks for your reply and taking the time to do this. I did end up coding manually. So thanks again! -
inverse poisson using perl (Math::CDF)
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... -
rotated text, blockquote
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...- spperl
- Thread
- Replies: 0
- Forum: HTML, XHTML & CSS
-
league table, cumulative ranking
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... -
Calculating Winning and Losing Streaks?
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... -
AJAX panel with form, IE issues
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...- spperl
- Thread
- Replies: 3
- Forum: HTML, XHTML & CSS
-
AJAX panel with form, IE issues
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... -
Spreadsheet::WriteExcel
Just an update if anyone was wondering: Spreadsheet::ParseExcel::SaveParser allows existing xls files to be edited. -
Spreadsheet::WriteExcel
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... -
regexp_matches
OK just figured this out ... 'thinking aloud' seems to help! select * from items where to_char(price,'99999.99') ~ '5$'; works well.- spperl
- Post #4
- Forum: PostgreSQL Inc.: PostgreSQL
-
regexp_matches
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...- spperl
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
regexp_matches
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.- spperl
- Thread
- Replies: 4
- Forum: PostgreSQL Inc.: PostgreSQL
-
Net::Amazon and Net::Amazon::Property
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! -
Net::Amazon and Net::Amazon::Property
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... -
converting codepage 437 to standard ASCII
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...
