Max 127 records

2002-04-19 Thread Henning Olsen
Hey - can anyone help? I have a MySql-db in which I can only have 127 records. Using phpmyadmin to insert record number 128 (autoincrement) gets this message: INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`, `telefon`, `kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg',

SV: Max 127 records

2002-04-19 Thread Carsten Gehling
Fra: Henning Olsen [mailto:[EMAIL PROTECTED]] Sendt: 19. april 2002 14:39 Hey - can anyone help? I have a MySql-db in which I can only have 127 records. Using phpmyadmin to insert record number 128 (autoincrement) gets this message: INSERT INTO `kontakt` (`id`, `navn`, `adresse`,

Re: Max 127 records

2002-04-19 Thread Fred van Engen
Hi, On Fri, Apr 19, 2002 at 01:38:49PM +0100, Henning Olsen wrote: Hey - can anyone help? I have a MySql-db in which I can only have 127 records. Using phpmyadmin to insert record number 128 (autoincrement) gets this message: INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`,

Re: Max 127 records

2002-04-19 Thread Steve Buehler
WowI think I can finally help somebody on this list. Ok. I bet that you have your column set up as tinyint. I presume it would be the id column that you have. tinyint is the following: Signed values: -128 to 127 Unsigned values: 0 to 255 I ran into the problem before too. So if you want

Re: Max 127 records

2002-04-19 Thread Ciprian Trofin
A closed mouth maintains a happy mind. It could be that you specified signed TINYINT as type for the PRIMARY KEY. Signed TINYINT goes from -127 to 127, hence your problem. HO INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`, HO `telefon`, `kommentar`) VALUES ('',

RE: Max 127 records

2002-04-19 Thread Roger Baklund
* Henning Olsen I have a MySql-db in which I can only have 127 records. Using phpmyadmin to insert record number 128 (autoincrement) gets this message: INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`, `telefon`, `kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg',

Re: Max 127 records

2002-04-19 Thread Egor Egorov
Henning, Friday, April 19, 2002, 3:38:49 PM, you wrote: HO Hey - can anyone help? HO I have a MySql-db in which I can only have 127 records. HO Using phpmyadmin to insert record number 128 (autoincrement) gets this message: HO INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,

Re: Max 127 records

2002-04-19 Thread Richard Emery
through 255. FYI: show us your table structure next time; please don't force us to guess your structure - Original Message - From: Henning Olsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 7:38 AM Subject: Max 127 records Hey - can anyone help? I have a MySql-db