Search results for query: *

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

...date_id, team_id, hpld hpld, htw, htd, htl, apld, atw, atd, atl from ( select r1.date_id, r1.home_team_id as team_id, count(*) as hpld, 0 as apld, sum( IF( r2.home_team_ft_score > r2.away_team_ft_score, 1, 0 ) ) htw, sum( IF(...

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

Hi, More specific question. The following query does not appear to work on v8.3.14: select * from table, to_tsquery('english','car:*') as query WHERE to_tsvector('english', title) @@ query ERROR: syntax error in tsquery: "car:*" Does anyone know if this functionality was brought in on a...

Hi, Does anyone know if it is it possible to do a like search using to_tsquery? e.g. to_tsquery('english','search_term*') AS query or to_tsquery('english','car*') AS query this would match car, card, care, cardio etc.. etc.. The tests I have done so far appear to suggest this isn't...

Hi, Please ignore, all was ok with the above code... the id I passed into the procedure for test purposes was wrong. Doh! Thanks again to carp yesterday for pointing me in the right direction. Cheers, spperl

Hi, Thanks for your previous comment regarding ref cursors yesterday... I've had a look and now think I'm a bit closer to being able to retrieve a recordset from multiple tables however still having difficulty. Here is the code written so far: Package definition to hold the ref cursor...

Hi, Thanks for the quick reply, guidance and pointers to alternative solutions - this gives me something concrete to look into. Thanks again.