Re: [sqlite] IP from number with SQL

2009-03-17 Thread Alexey Pechnikov
Hello! On Sunday 15 March 2009 23:10:02 Roger Andersson wrote: The SQL below might be out there but I didn't find it and since there might be other that need to get 32-bit integer IP in a sqlite3 database to the a.b.c.d format using SQL There is extension for ipv4

Re: [sqlite] IP from number with SQL

2009-03-16 Thread Roger Andersson
Thanks John, appreciated! -Ursprungligt meddelande- Från: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] För John Machin Skickat: den 16 mars 2009 00:51 Till: sqlite-users@sqlite.org Ämne: Re: [sqlite] IP from number with SQL On 16/03/2009 8:48 AM, Kees Nuyt

[sqlite] IP from number with SQL

2009-03-15 Thread Roger Andersson
Hi! The SQL below might be out there but I didn't find it and since there might be other that need to get 32-bit integer IP in a sqlite3 database to the a.b.c.d format using SQL I did get started from http://acidlab.sourceforge.net/acid_faq.html#faq_e1 and for me what's below does the trick in

Re: [sqlite] IP from number with SQL

2009-03-15 Thread Kees Nuyt
On Sun, 15 Mar 2009 21:10:02 +0100, Roger Andersson r...@telia.com wrote: Hi! The SQL below might be out there but I didn't find it and since there might be other that need to get 32-bit integer IP in a sqlite3 database to the a.b.c.d format using SQL I did get started from

Re: [sqlite] IP from number with SQL

2009-03-15 Thread John Machin
On 16/03/2009 8:48 AM, Kees Nuyt wrote: On Sun, 15 Mar 2009 21:10:02 +0100, Roger Andersson r...@telia.com wrote: Hi! The SQL below might be out there but I didn't find it and since there might be other that need to get 32-bit integer IP in a sqlite3 database to the a.b.c.d format using