All is going well with my first database. Only one problem. I logon and add a new record. It goes great and the "acceptance" page says I added it. I immediately add a second record. The next screen only shows only the first three fields ... and no data in those. This abbreviated screen says the record was added and, in fact, the record has in fact been added. Why doesn't the second (and subsequent) "acceptance" sheet show the full record? There seems to be no other problems. All the sorting, modification and deleting goes well. Any advice would be appreciated.
Thanks

I dunno. This is a new one.

Try setting $db_auto_generate = 1; in your .cfg file. If things work with autogenerate, the problem is (probably) in your html.pl file. If they don't, the problem is in your .cfg file.


JPD
http://www.jpdeni.com/dbman/

When I set the $db_auto_generate = 1, then the add record returns no data in the "accepted" form. The fields are shown. The second add also shows an empty record. However, the record is added and it is correct. So, I guess the problem is in the html.pl file? Any idea where to start looking?

Then your problem is in your .cfg file.

There could be several things. Did you set a $db_key field? Have you changed the number of fields since you first added a record? Those are the first two things that come to mind

If you'd like me to take a look at your .cfg file, copy it to a web-accessible directory (one where you would place .html files) and rename it to default_cfg.txt. Then come back here and tell me where I can pick it up.


JPD
http://www.jpdeni.com/dbman/

You are right!! The problem was that I had set $auth_user_field incorrectly in the cfg. I had thought I set it to the UserID (my number 2), but instead I set it to the "ID" field (my number 0). When I set it correctly all problems went away!!! Thanks for all your help!!

You're welcome.

A lot of this is just narrowing down where the possible problems are so you know where to look.

JPD
http://www.jpdeni.com/dbman/