RE: Database accepts only 127 records

2001-05-25 Thread Jon Haworth
Define your tables so you're not using TINYINT as your primary key - it has a maximum size of 127. If you use INTEGER you should be fine. HTH Jon -Original Message- From: Jari Mäkelä [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 12:29 To: [EMAIL PROTECTED] Subject: Database accepts only

Re: Database accepts only 127 records

2001-05-25 Thread Jason Brooke
> Hi, > got a problem as mysql does not allow writing but 127 entries to a > database, any idea how to correct this abnormality? > Jari Mäkelä You probably created an auto-increment field of type tinyint - check the data specification for tiny int in the online manual to see whay it's happening