Re: Getting the latest related record from a SQL DB

2014-10-10 Thread Jonathan McKeown
On 10 Oct 2014 18:24, David Cantrell da...@cantrell.org.uk wrote: I don't think that LIMIT is standard SQL so it won't be supported everywhere. True. {FIRST|NEXT} {ROW|n ROWS} ONLY seems to be in a recent SQL standard (2008?) but I don't think it or any other idiom is universal. And also I

Re: Getting the latest related record from a SQL DB

2014-10-09 Thread Jonathan McKeown
On 9 Oct 2014 18:34, Andrew Beverley a...@andybev.com wrote: Hi guys, I'm after some best-practice advice regarding SQL database design. SWAG (swift wild-arsed guess) rather than best practice [snip] So, if I want to know all of an artist's albums, that's easy. But what if I want to

Re: Getting the latest related record from a SQL DB

2014-10-09 Thread Jonathan McKeown
ORDER BY date DESC - not DESCENDING

Re: Updating lots of database fields in a single row

2013-01-24 Thread Jonathan McKeown
On Jan 24, 2013 7:32 PM, Greg McCarroll g...@mccarroll.org.uk wrote: Perl was never cool, it was the kid that liked wearing a sports coat to school with leather patches sewn on the elbows as they took style tips from their 'cool' maths teacher. Oi, I resemble that remark! /me wonders what

Re: [ANNOUNCE] London Perl Mongers Technical Meeting 2012-04-11

2012-02-29 Thread Jonathan McKeown
Having attended one of Damian's talks before, I'd quite happily solve the logistical problems involved in getting there from the Eastern Cape to hear this one. Unfortunately international distance is measured in money, not time. Jonathan

Re: Worst Recruitment Experience

2011-12-09 Thread Jonathan McKeown
The Guardian's Corrections and Clarifications are often worth reading. This is one of my personal favourites: A rigid application of the Guardian style guide caused us to say of Carlo Ponti in his obituary, page 34, January 11, that in his early career he was already a man with a good eye for

Re: Lovefilm, yes or no?

2010-04-15 Thread Jonathan McKeown
On Wednesday 14 April 2010 17:46:30 Bob Walker wrote: On Wed, 14 Apr 2010, ian wrote: On 14/04/2010 14:05, Peter Edwards wrote: I was once asked at an interview 'how many digits of PI do you know?'. enough. although id much rather cancel pi out. which is why it is useful to know that

Re: Lovefilm, yes or no?

2010-04-14 Thread Jonathan McKeown
On Wednesday 14 April 2010 15:05:51 Peter Edwards wrote: Funniest interview question I heard of recently (not Lovefilm) was: What's two to the power 14 As in, work out the answer there and then 2^10 (1024) is roughly 10^3, so 2^4 x 2^10 is roughly 16 thousand. If you can't remember the power

Re: Skype

2009-09-18 Thread Jonathan McKeown
On Thursday 17 September 2009 20:10:07 Paul Makepeace wrote: Talking of sip, does anyone have recommendations for consumer voip services? Ideally I'd like something I can make (direct dial) calls from on my laptop+headset and it'd appear as a e.g. UK mobile. And take calls on that number,

Re: Cheap perl e-books

2009-08-26 Thread Jonathan McKeown
On Wednesday 26 August 2009 01:05:49 Andrew Smith wrote: [...]illegal downloaded pdf's[...] He sees them, even if you only look before buying the book as totally wrong and a criminal offence. s/He/Copyright law in most countries/ T,FTFY. HTH, HAND. Jonathan

Re: Chainsaws (was [ANNOUNCE] London.pm technical meeting about What is Moose....)

2009-01-28 Thread Jonathan McKeown
On Wednesday 28 January 2009 09:53:16 Nicholas Clark wrote: On Wed, Jan 28, 2009 at 12:10:01AM +, Edmund von der Burg wrote: use the spikes to pivot the blade through the wood. NEVER cut using the top of the blade. (That last bit is actually important). I'm guessing that there's more

Re: [OT] Perl woes

2009-01-28 Thread Jonathan McKeown
On Wednesday 28 January 2009 14:01:22 Paul Makepeace wrote: Interesting that everyone's said to use warnings but no-one's questioned what you're saying. Perl appears to me to DTRT: $ perl -le 'print yes if a == 2' $ perl -le 'print yes if a == a' yes $ perl -le 'print yes if 1 == 1' yes

Re: [OT] Perl woes

2009-01-28 Thread Jonathan McKeown
On Wednesday 28 January 2009 14:30:20 Jonathan Kimmitt wrote: However, what about this one: for (my $i==0; $i($tbl_width - 1); $i++) { } Is anybody seriously arguing this could possibly do anything useful. Yet it is not trapped out as an error unless you add the obscure syntax: use

Re: [OT] Perl woes

2009-01-28 Thread Jonathan McKeown
On Wednesday 28 January 2009 15:24:43 Jonathan Stowe wrote: 2009/1/28 Jonathan McKeown jonathan+londo...@hst.org.za: On Wednesday 28 January 2009 14:30:20 Jonathan Kimmitt wrote: However, what about this one: for (my $i==0; $i($tbl_width - 1); $i++) { } Is anybody seriously

Re: Invitation to connect on LinkedIn

2008-10-15 Thread Jonathan McKeown
On Wednesday 15 October 2008 15:33:42 Roger Burton West wrote: On Wed, Oct 15, 2008 at 06:13:09AM -0700, a bot claiming to be Ot??vio Fernandes wrote: I'd like to add you to my professional network on LinkedIn. Ah well, I suppose it was useful to some people while it lasted. Now I guess it's

Re: [josette@oreilly.co.uk: Newsletter issue 02-9]

2002-05-29 Thread Jonathan McKeown
--On Wednesday 29 May 2002 15:33 +0100 Paul Mison [EMAIL PROTECTED] wrote: Still, we have quite a lot of outstanding reviews, some of which are really quite old indeed: [snip] Programming Jabber - Robert Shiels (?) No, that's me. It will be done soon. Jonathan -- Jonathan McKeown, System

Re: Virus protection?!

2002-03-21 Thread Jonathan McKeown
--On Wednesday 20 March 2002 19:51 + Chris Benson [EMAIL PROTECTED] wrote: On Wed, Mar 20, 2002 at 06:43:17PM -, Jonathan McKeown wrote: It has certainly caught everything that's been thrown at it here (about 1 in 650 of our incoming messages is infected

Virus protection?!

2002-03-20 Thread Jonathan McKeown
detector said this about the message: Report: Attempt to hide real filename extension in College.ABDO.CET.doc Jonathan -- Jonathan McKeown, System Administrator. The College of Optometrists, 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 Incorporated by Royal Charter

Re: Virus protection?!

2002-03-20 Thread Jonathan McKeown
; and they are confident enough to offer a guarantee: if a single virus, known or unknown, gets through their screen we get a refund. It has certainly caught everything that's been thrown at it here (about 1 in 650 of our incoming messages is infected). Jonathan -- Jonathan McKeown, System Administrator

Re: [ANNOUNCE] Technical meeting tonight, reminder

2002-01-24 Thread Jonathan McKeown
will be travelling by public transport, so I can't really bring a screen. Can anyone else help? Jonathan -- Jonathan McKeown, System Administrator. The College of Optometrists, 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 Incorporated by Royal Charter and registered

Re: Of meetings technical and social

2002-01-18 Thread Jonathan McKeown
be frobbed). Jonathan -- Jonathan McKeown, System Administrator. The College of Optometrists, 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 Incorporated by Royal Charter and registered as a Charity No 1060431 http://www.college-optometrists.org mailto:[EMAIL PROTECTED

Re: Of meetings technical and social

2002-01-18 Thread Jonathan McKeown
No 107! Jonathan -- Jonathan McKeown, System Administrator. The College of Optometrists, 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 Incorporated by Royal Charter and registered as a Charity No 1060431 http://www.college-optometrists.org mailto:[EMAIL PROTECTED

Re: tech meet tonight

2001-11-22 Thread Jonathan McKeown
to just plug it in and go. I will bring one. Jonathan -- Jonathan McKeown, System Administrator. The College of Optometrists, 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 Incorporated by Royal Charter and registered as a Charity No 1060431 http://www.college

RE: Classic Computer Books (Non-Perl)

2001-10-18 Thread Jonathan McKeown
anniversary edition. Jonathan -- Jonathan McKeown, System Administrator. The College of Optometrists, 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 Incorporated by Royal Charter and registered as a Charity No 1060431 http://www.college-optometrists.org mailto:[EMAIL PROTECTED

Re: afterquoting (was: Friday Morning Fun)

2001-09-21 Thread Jonathan McKeown
for a restricted subset of strings? Jonathan -- Jonathan McKeown, System Administrator, The College of Optometrists 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 http://www.college-optometrists.org mailto:[EMAIL PROTECTED

Pubs

2001-09-20 Thread Jonathan McKeown
month - I just wondered what was the driving force for change. -- Jonathan McKeown, System Administrator, The College of Optometrists 42 Craven Street London WC2N 5NG. Tel: +20 7839 6000 Fax: +20 7839 6800 http://www.college-optometrists.org mailto:[EMAIL PROTECTED

Re: Pubs

2001-09-20 Thread Jonathan McKeown
, Chairman of Wetherspoon's and a supporter of Business for Sterling, agreed to place leaflets and beermats presenting the No case in Wetherspoons pubs. This is not universally popular. Jonathan -- Jonathan McKeown, System Administrator, The College of Optometrists 42 Craven Street London WC2N 5NG