Gossamer Forum
Home : Products : DBMan : Customization :

Can you use DBMan without a key value?

Quote Reply
Can you use DBMan without a key value?
I'd like to use DBMan as a data reader only. The database will be created as a form mail log file by another script, and that script isn't able to create unique key values for each record. The user in DBMan will have only view/own permissions. In my small test database it seems to work fine--even with duplicate records--but I'm concerned that as the database grows the lack of a key might mess the whole thing up.

Anyone have any experience with this?

Thanks,

Jeff
Quote Reply
Re: Can you use DBMan without a key value? In reply to
Just change the following variable in the default.cfg file:

Code:
$db_key_track = 1;

to the following:

Code:
$db_key_track = 0;

But it would be unwise to not have a $db_key, because you may have duplicate records.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------








Quote Reply
Re: Can you use DBMan without a key value? In reply to
Eliot,

Thanks for the quick response.

I had considered that, but I assumed the $db_key_track configuration was just a counter log so the script could add new key values if there's an ID field--which I don't have. Duplicate records for me aren't likely--although not a problem if it does happen. My only concern is that the user will still be able to read their own mailform logs, duplicate records and all.

Anyway, I'll give it a try and see what happens. Thanks again.

Jeff