RE: Generating an automatic e-mail via MySQL

2003-02-12 Thread Karl Dyson
I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Something like: == #!/usr/bin/perl use strict; use warnings; use diagnostics; use DBI; my $dbname = 'DBI:$driver:database=database;host=dbserver.blah.com'; my $dbuser = 'dbusername'; my $

RE: Percentile calculations

2003-02-09 Thread Karl Dyson
); Thanks for all help supplied, Karl -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: 05 February 2003 18:32 To: 'Benjamin Pflugmann'; Karl Dyson Cc: [EMAIL PROTECTED] Subject: RE: Percentile calculations I believe you can do: select avg(scantime) from pe

Percentile calculations

2003-01-31 Thread Karl Dyson
I've had a look through the archives and cannot see a solution to this. I am wondering if there is a nicer way to do the following. I have a table where one of the columns contains a time period for an activity that I am logging. I need to grab the 95th percentile, when ordered by duration. I have