I am building a database that have 17 fields. However I don't know why, at the eleventh field which is a "numer" input, the user name is always inserted instead of the actual value eg...."admin" instead of "1999"

I read a posting in the FAQ section about similar problem. However that posting is not clear as to how the problem is solved. I Hope someone could gladly help me on this. Thanks in advance.

PS: I am using the auto_generate form function. So I guess it is not thr problem of the "html.pl" file.

Are you sure it's the eleventh field? Could it be field 9?

The reason I ask is that the default.cfg file that comes with the distribution sets the userid field to 9. If you haven't changed it, the that field will be set to the userid, no matter what other things you define for the field.

If it is a field other than field 9, you have changed the $auth_user_field variable, but to the wrong value.

If you are not using a user id field, set $auth_user_field to -1.

Just to be on the safe side, I would double-check the numbering of the fields to make sure you haven't left out a number somewhere.

------------------
JPD

Thanks very much

That really helps. I just forgot to set the userid field to -1

Best Wishes to you :-)