I am using a multiple database system with 13 different db's and html files that pretty much have all the same fields with the exception of the "Category" field which I have hidden and have included a default selection based on the database the record is being added to.

Unfortunately this is not working and it is adding all records to the same db and not the one that I am specifying.

Has anyone had this same problem? I'm confused...any help would be greatly appreciated

Cher

How do you have your links to your DBs setup?

Borrowing from Loisc's recent post in the multiple html thread ...

/db.cgi?db=new

what is your hidden variable like?

probably your hidden variable isn't set right or the first link area that your users go through is slightly off.

posting these code areas also might help us to look for the problem area.

good luck

---

openoffice + gimp + sketch ...

The databases each have their own cfg and html file. They share the same default.pass file. When I try to access the database form to add a record I type http://www.mydomain.com/cgi-bin/dbman/db.cgi?db=datebasename&signup_form=1 which takes me to the form which "I am assuming" is the form for the database that I have specified. (FYI I added a mod so users submit a new record when they signup) Unfortunately it doesn't matter which database I specify in the http because it dumps all entries into only one of the databases.

I just don't get it? Any clues?


Cher

sort of sounds like your config file per db isn't sending you to the right area ....

1.) check again to make sure your config is set correctly. Check the area below ...

# File and URL's
# --------------------------------------------------------
# URL of the directory dbman resides in. No Trailing Slash Please.
$db_dir_url = "http://127.0.0.1/cgi-bin/dbman";
.....
# Database Definition

2.) as a test procedure ... are your html.pl s different or do they look the same ? you might want to temporarily do something like add a background color and use a different color on each ... yeah I know a little torublesome but at least you know for sure that you're in the right html.pl section ...

3.) like I said some code will help us to help you better ...

good luck

---

openoffice + gimp + sketch ...