Gossamer Forum
Home : Products : DBMan : Customization :

Relational question

Quote Reply
Relational question
I used JP Deni's Relational demo & modified it to work for a key code database I am making.

Everything seemed to be working as I started entering things, but I just noticed that now an error is showing up.

If I enter up to two items into the database for a user it all works fine. But, when I add a 3rd item or a 4th...the "Area" link no longer shows up and instead it switches to the ID number.

Take a look (userID: admin pw: admin)

http://www.d-rae.com/rela/db.cgi

Once in type in the last name Abraham & then click on the top one Abraham, Daniel.

When you click on his link you will see 3 entries. The first two are correct (showing the areas the keys are for). But, when I entered the 3rd item it didn't give the Area, but instead the autoID number (it is showing the ID number 3 instead of Suite 800 & 710 which I did type and does show up if you actually do an item search on ID 3).

I didn't enter it in a different way, so it has to be something in the code that I messed up, but I'm not sure where to look.

Here is the text files of my files:

http://www.d-rae.com/test/

Any help as to what I must fix would be greatly appreciated.
Diana Rae
Quote Reply
Re: [dianarae] Relational question In reply to
I just noticed something. After I did the user search on Abraham, Daniel... when I put my mouse over the links...

805 MASTER - the link shows:

http://www.aallsafe.com/med/db.cgi?db=item&uid=default&ItemID=1&view_records=1

Ste 715 - the link shows:

http://www.aallsafe.com/med/db.cgi?db=item&uid=default&ItemID=2&view_records=1

BUT for where Suite 800 & 710 should be and it is showing the ItemID 3 the link shows:

http://www.aallsafe.com/med/db.cgi?db=item&uid=default&ItemID=AbrahamD&view_records=1

It should be ItemID=3 there and should not be ItemID=AbrahamD. I entered them all in the exact same way, but when I get to a 3rd or 4th entry it automatically changes to showing the ItemID instead of the Area link.

Again, any help or guidance would greatly be appreciated.
Diana Rae
Quote Reply
Re: [dianarae] Relational question In reply to
*bump*

Anyone able to help me shed light on this? :(
Diana Rae
Quote Reply
Re: [dianarae] Relational question In reply to
Did you add or change fields in the database after records had been entered? If you did and did not make the same changes to data already in the db, you'd be reading the fields out of sequence.
Quote Reply
Re: [Karen] Relational question In reply to
Karen, I decided to see if what you said was perhaps the problem. So I cleared out every entry in the user database and the item database and started fresh.

I created a user named: test with the password: test

If you go to this link: http://www.aallsafe.com/med/db.cgi and enter that user name & password then hit the Search by Customer then enter the Customer name: test You will see at the bottom that the first 2 are correct (below) by showing the links by area. Yet the 3rd and 4th entry automatically switch to Item Id number again instead of the area.

I cannot figure out why it changes after the 2nd entry is made and the 3rd is entered? Something in some coding somewhere is not write & I just dont know what I am missing.

The files are here: http://www.d-rae.com/test/

Any help at all would greatly be appreciated.

Laugh
Diana Rae
Quote Reply
Re: [dianarae] Relational question In reply to
I don't have time now to check your files, but what you should look for first is that in your .cfg files you have the fields numbered consecutively, and that your userid field is defined for the correct field.

Then check your input forms and make sure you have all the fields listed. Also double check to be sure that you didn't make any typos in the field names.

I may have time to check over your files later tonight if you still haven't found the problem.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Relational question In reply to
I was unable to login with the test user you setup to view your database, but looked over your files and didn't see anything out of the ordinary in the record_form section or .cfg files.

Are you still having problems? Have you opened the database to see if the records are being stored correctly.
I'm trying to figure out if the db is corrupt or the problem is just when displaying?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/