Ahh..you're not an ASP guy...sorry!

[Jim Rudnick]

Sorry Nick...I thought you were an ASP coder as well as an mySQL expert.

ASP does NOT require that you do an INSERT to place data in a dbase table, never did in fact.

Instead (and this was the original way they launched ASP with) you can simply call for a single record set...which I do with SELECT *

then use rs.AddNew and change any of those dbase table fields to new values and then do a simple rs.Update. This saves the new record as it's ownself...

Which is the way that I coded this simple asp page...you do NOT need to use INSERTS or any such other way.

And as you know, this works FINE if I use a 3 char name, but no more than 3.

The problem continues to still exist and I'm pretty frustrated by same....

Also I do not understand (my turn?) what you mean by "updating the table with a 5 letter name direclty from the mysql prompt.." either what you mean or how to try same???

Jim