Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-09 Thread Robert Kern
On 2013-11-09 04:27, Piet van Oostrum wrote: Sibylle Koczian nulla.epist...@web.de writes: Am 07.11.2013 14:14, schrieb Piet van Oostrum: Nick the Gr33knikos.gr...@gmail.com writes: I have decided to take your advice. I wasn't able to fit those 'lists' of mine into MySQL's varchar()

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-08 Thread Piet van Oostrum
Sibylle Koczian nulla.epist...@web.de writes: Am 07.11.2013 14:14, schrieb Piet van Oostrum: Nick the Gr33knikos.gr...@gmail.com writes: I have decided to take your advice. I wasn't able to fit those 'lists' of mine into MySQL's varchar() datatype after converting them to long strings and

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Piet van Oostrum
Nick the Gr33k nikos.gr...@gmail.com writes: I have decided to take your advice. I wasn't able to fit those 'lists' of mine into MySQL's varchar() datatype after converting them to long strings and that sads me. My implementation is like the following. I do not use an extra table of

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 6/11/2013 7:59 μμ, ο/η Denis McMahon έγραψε: On Wed, 06 Nov 2013 09:30:03 +0200, Nick the Gr33k wrote: I have decided to take your advice. No you haven't. You only think you have, but really you either haven't understood the advice at all. My implementation is like the following. I do

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Joel Goldstick
On Thu, Nov 7, 2013 at 8:37 AM, Νίκος Αλεξόπουλος nikos.gr...@gmail.com wrote: Στις 6/11/2013 7:59 μμ, ο/η Denis McMahon έγραψε: On Wed, 06 Nov 2013 09:30:03 +0200, Nick the Gr33k wrote: I have decided to take your advice. No you haven't. You only think you have, but really you either

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 3:52 μμ, ο/η Joel Goldstick έγραψε: 2. the download is remained associated with the person that made the download since all this info is placed in the same record. just think, all those folks who figured out databases were wrong. Nikos has shown that you just need to put

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Chris Angelico
On Fri, Nov 8, 2013 at 1:09 AM, Νίκος Αλεξόπουλος nikos.gr...@gmail.com wrote: Why create a whole new 'downloads' table and associate it with the with a foreign key with the 'visitors' table you idiot when you can just have an extra column at the end of the current 'visitor's table? Both

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Joel Goldstick
On Thu, Nov 7, 2013 at 9:37 AM, Chris Angelico ros...@gmail.com wrote: On Fri, Nov 8, 2013 at 1:09 AM, Νίκος Αλεξόπουλος nikos.gr...@gmail.com wrote: Why create a whole new 'downloads' table and associate it with the with a foreign key with the 'visitors' table you idiot when you can just

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Grant Edwards
On 2013-11-07, ?? ?? nikos.gr...@gmail.com wrote: [nothing my newsreader cared to keep] OK, so when posting a follow-up, Nikos is now putting his entire posting into his signature? This guy's a hoot-and-a-half! -- Grant Edwards grant.b.edwards

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Sibylle Koczian
Am 07.11.2013 14:14, schrieb Piet van Oostrum: Nick the Gr33knikos.gr...@gmail.com writes: I have decided to take your advice. I wasn't able to fit those 'lists' of mine into MySQL's varchar() datatype after converting them to long strings and that sads me. My implementation is like the

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Tim Chase
On 2013-11-07 17:03, Sibylle Koczian wrote: Nikos, you are an excellent member of the Greek society. Listening to you makes it so much easier to understand the problems that your country has. Is there any reason at all to insult all other Greek readers of this newsgroup? Greece is no

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 5:11 μμ, ο/η Joel Goldstick έγραψε: On Thu, Nov 7, 2013 at 9:37 AM, Chris Angelico ros...@gmail.com wrote: On Fri, Nov 8, 2013 at 1:09 AM, Νίκος Αλεξόπουλος nikos.gr...@gmail.com wrote: Why create a whole new 'downloads' table and associate it with the with a foreign key with

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Neil Cerutti
On 2013-11-07, ?? ?? nikos.gr...@gmail.com wrote: I called you an idiot, because in your previous and current message you called me too. I know that splitting information across tables and maintain foreign keys for retain relationships between them is a necessary

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 8:08 μμ, ο/η Neil Cerutti έγραψε: On 2013-11-07, ?? ?? nikos.gr...@gmail.com wrote: I called you an idiot, because in your previous and current message you called me too. I know that splitting information across tables and maintain foreign keys for

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-06 Thread Nick the Gr33k
Στις 6/11/2013 9:38 πμ, ο/η Nick the Gr33k έγραψε: Ah great!!! I just examined my other MySQL database which just stored webpages and their corresponding visits and voila. Someone was able to pass values into my counters table: look: http://superhost.gr/?show=stats thats why it didn't had 1

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-06 Thread Denis McMahon
On Wed, 06 Nov 2013 09:30:03 +0200, Nick the Gr33k wrote: I have decided to take your advice. No you haven't. You only think you have, but really you either haven't understood the advice at all. My implementation is like the following. I do not use an extra table of downlaods that i

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-06 Thread rusi
On Wednesday, November 6, 2013 11:29:11 PM UTC+5:30, Denis McMahon wrote: On Wed, 06 Nov 2013 09:30:03 +0200, Nick the Gr33k wrote: I have decided to take your advice. No you haven't. You only think you have, but really you either haven't… No, you think that he thinks that he has. Of

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-06 Thread Mark Lawrence
On 06/11/2013 17:59, Denis McMahon wrote: On Wed, 06 Nov 2013 09:30:03 +0200, Nick the Gr33k wrote: I have decided to take your advice. No you haven't. You only think you have, but really you either haven't understood the advice at all. My implementation is like the following. I do not use

Adding 'download' column to existing 'visitors' table (as requested)

2013-11-05 Thread Nick the Gr33k
I have decided to take your advice. I wasn't able to fit those 'lists' of mine into MySQL's varchar() datatype after converting them to long strings and that sads me. My implementation is like the following. I do not use an extra table of downlaods that i asoociate with table visitors with a

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-05 Thread Nick the Gr33k
Ah great!!! I just examined my other MySQL database which just stored webpages and their corresponding visits and voila. Someone was able to pass values into my counters table: look: http://superhost.gr/?show=stats thats why it didn't had 1 or 2 or 3 as 'counterID' but more values were