On 10 Oct 2014 18:24, "David Cantrell" 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 don't think that
ORDER BY date DESC - not DESCENDING
On 9 Oct 2014 18:34, "Andrew Beverley" 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 fetch a
On Jan 24, 2013 7:32 PM, "Greg McCarroll" 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 happened to that coa
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
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 pre
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
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 p
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, p
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
On Wednesday 28 January 2009 15:24:43 Jonathan Stowe wrote:
> 2009/1/28 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++) { }
>
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:
>
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
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 m
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
--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
--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 o
can claim to be scanning for unknown as well as known viruses; 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 inco
present and should be checked.
>
> The virus 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 78
either baffles or scares me (or both) and feel that although I'm
not at that level of knowledge, I'm in a group that has members who are and
where I am welcome. I would find it a shame if all the brain-stretching
stuff migrated to another list: I like to know someone's doing it ev
x27; of the
various groups mean everyone can find a place, and a level of commitment,
they are comfortable with within the community.
An interesting variation of Paul's question might be: what was your point
of entry to the Perl community, are you still an active member there, and
how else
ging the projector, but I 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 Roy
th a tiny brass plate for
codix - also allegedly 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-op
rameters that can 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 mai
e my slides on my laptop, and I was hoping 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
et it back from my PHB the next in line is The Mythical
Man-Month (Brooks) - again it's the recently released 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
Incorpor
sted :-)
But also surely only works 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-optometris
m, statement with
two operators (one with the side-effect of assigning a value to $i) -
what's the precedence? And looked it up because "It may seem to you that
there are too many precedence levels to remember. Well, you're right, there
are" (Camel 3 p88).
I'm still in
9
but in short, Tim Martin, 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 Optometrist
A good-sized private room would be a Good Thing.
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]
same place each 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:[
31 matches
Mail list logo
