>>What do you mean by this? It's quite a confusing statement. Could you clarify?
I was wondering why a MySQL table was only allowing 10 record insertions. Solved it. Inserting int data into a field set to varchar datatype only allowed to me insert 9 records, the 10 th record cause I had with autoincrement setup in a groupid field was giving a duplicate data error, the 1 in the 10 was tripping/stopping any more data being inserted. The error was not having the fieldtype set to INT, dono why I set the fieldtype to varchar in the first place. I suppose you could use this if you wanted a table to allow only 10 insertions. Colm -----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 07 March 2003 15:47 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT----MySQL > Anybody know how to limit the number of records that can be > inserted in a field or table in MySQL, using MySQL-Front, > also how to allow duplicate records. What do you mean by this? It's quite a confusing statement. Could you clarify? Paul PS Why do you want to duplicate records? -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
