Re: [Hampshire] Port scans

2009-12-06 Thread john
Hi I had a problem with timeouts when BT updated their local exchange and I could not get a proper service until I altered the MTU. John Eayrs On Sunday 06 December 2009 21:53:44 Rob Malpass wrote: > - Original Message - > From: "Dee Earley" > To: "Hampshire LUG Discussion List" > S

Re: [Hampshire] SQL SELECT query.

2009-12-06 Thread Philip Stubbs
2009/12/6 Hugo Mills : >   SQL is really, really bad at this kind of job, I'm afraid. If you > want precisely the longest way, it's going to have to look something > like this, I think: > > SELECT way,highway,aeroway,name,ref,char_length(ref) AS length, >  ST_Length(way) AS road_len, >  CASE WHEN b

Re: [Hampshire] SQL SELECT query.

2009-12-06 Thread Hugo Mills
On Sun, Dec 06, 2009 at 09:53:56PM +, Philip Stubbs wrote: > 2009/12/6 Hugo Mills : > > On Sun, Dec 06, 2009 at 07:32:25PM +, Philip Stubbs wrote: > >> Hi, > >> > >> I have been playing with mapnik to create some maps. It has been fun, > >> but I am a bit lacking in Postgres SQL. Can anybod

Re: [Hampshire] Port scans

2009-12-06 Thread Rob Malpass
- Original Message - From: "Dee Earley" To: "Hampshire LUG Discussion List" Sent: Sunday, December 06, 2009 9:33 PM Subject: Re: [Hampshire] Port scans > Something is making me think that the nat connection table is full so it > doesn;t recognise the data coming back. > This may be do

Re: [Hampshire] SQL SELECT query.

2009-12-06 Thread Philip Stubbs
2009/12/6 Hugo Mills : > On Sun, Dec 06, 2009 at 07:32:25PM +, Philip Stubbs wrote: >> Hi, >> >> I have been playing with mapnik to create some maps. It has been fun, >> but I am a bit lacking in Postgres SQL. Can anybody help me to adjust >> the following SELECT statement so that it will retur

Re: [Hampshire] Port scans

2009-12-06 Thread Dee Earley
On 06/12/2009 21:02, Rob Malpass wrote: > Hi all > I need a bit of networking advice. Recently my network (or rather > connection to the internet) has "stalled". By this I mean I'm using > firefox (admittedly on Vista) and I've noticed that say I'm heading to > wikipedia - it just times out. If I o

[Hampshire] Port scans

2009-12-06 Thread Rob Malpass
Hi all I need a bit of networking advice. Recently my network (or rather connection to the internet) has "stalled". By this I mean I'm using firefox (admittedly on Vista) and I've noticed that say I'm heading to wikipedia - it just times out. If I open another tab sometimes this fixes it

Re: [Hampshire] SQL SELECT query.

2009-12-06 Thread John Cooper
On 06/12/09 19:32, Philip Stubbs wrote: > Hi, > > I have been playing with mapnik to create some maps. It has been fun, > but I am a bit lacking in Postgres SQL. Can anybody help me to adjust > the following SELECT statement so that it will return a result set > that consists of only one of each d

Re: [Hampshire] SQL SELECT query.

2009-12-06 Thread Hugo Mills
On Sun, Dec 06, 2009 at 07:32:25PM +, Philip Stubbs wrote: > Hi, > > I have been playing with mapnik to create some maps. It has been fun, > but I am a bit lacking in Postgres SQL. Can anybody help me to adjust > the following SELECT statement so that it will return a result set > that consist

[Hampshire] SQL SELECT query.

2009-12-06 Thread Philip Stubbs
Hi, I have been playing with mapnik to create some maps. It has been fun, but I am a bit lacking in Postgres SQL. Can anybody help me to adjust the following SELECT statement so that it will return a result set that consists of only one of each distinct 'name'? SELECT way,highway,aeroway,name,re