Hi,

I am using ASP and MySQL

I had this error when I was trying to make some entries into my database.



My database is "items"

fields are:

iSize VarChar(50)

iMaker VarChar(50)

iDesc VarChar(50)



My ASP Code is:


PHP Code:





 insrec.Open "items", MyDB, adOpenKeyset, adLockOptimistic, adCmdTable

insrec.AddNew

insrec("iSize") = pSize

insrec("iMaker") = pMaker

insrec("iDesc") = pDesc

insrec.Update 





pSize, pMaker and pDesc are coming from an entry form.

When I enter 8kg in Size field, I had no problems... but when I enter longer text like 350kg, 1300cm I had this error.



Actually I solved this problem using PHPMyAdmin, adding a row with maximum column values.

Like iSize="12345678901234567890123456789012345678901234567890"

iMaker="12345678901234567890123456789012345678901234567890"

iDesc="12345678901234567890123456789012345678901234567890"

I didn't chage the code or anything. After I made this entry, everything worked fine.

I solved the problem (in a weird way) but still cruious why is this happening. And is there any other way to fix this?

thanks in advance.