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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: spperl
  • Content: Threads
  • Order by date
  1. spperl

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

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

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

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

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

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

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

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

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

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

    Like Search using full text index

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

    PL/SQL ref cursors / multiple tables

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

    PL/SQL Associative Array

    Hi, Is it possible to populate an associative array (or similar) based on the results of a query that combines multiple tables. Pseudo code: DECLARE TYPE combinedTab IS TABLE OF combinedTab%ROWTYPE INDEX BY BINARY_INTEGER; combined_tab combinedTab; BEGIN SELECT tab1.col1, tab2.col2...
  14. spperl

    Dynamic form additions not retrievable by backend code

    Hi, I have a web form that has repeating sections that need to be persisted... these repeating sections are handled via AJAX so that the form is initially loaded it presents the minimum amount of information. When the 'add' button is clicked it will dynamically add another section to be filled...
  15. spperl

    Arrays?

    Hi, I'm creating a web widget using a backend programming language to produce some javascript. The widget itself is a simple link rotator. The part I'm having a problem with is setting up my array. The output I generate is as follows: var myquotes = new Array( "<a...
  16. spperl

    UK Postcode distance

    Hi, I've been on websites where it allows you to filter results based on a specified distance from a provided postcode. Two questions I have are as follows: 1. What is needed to make this possible, and, 2. Are there any perl modules out there that can assist? Any help would be gratefully...
  17. spperl

    File::Find for non recursive searching

    Hi, Hopefully someone can help here... my question is as follows: Is there a way to configure File::Find so that it 'stays' in the top directory and does not perform a recursive search? example of what I have that is not working? my @fileList=(); find ( { wanted => sub {push @fileList...
  18. spperl

    excel drop-down menu

    Hello, I am looking to create a spreadsheet with a drop-down menu of pre-determined fields, however am unsure how to do so. I am using microsoft office 2003. Any help would be appreciated. Thanks,
  19. spperl

    Videobox issues on IE?

    Hi, I;m using videobox to point to web videos on sites like you tube etc... I can get it working fine on Firefox however not properly on IE. On FF the correct fade our effect occurs and the video is central on the screen however on IE no fade occurs and it jumps to the top of screen (sometimes...
  20. spperl

    Unix terminal / consule GUI

    Hi, Does anyone know of any good perl modules or code that supports the creation of console gui applications? Any help or guidance would be appreciated. Thanks, spperl

Part and Inventory Search

Back
Top