Hello,

I have two questions if dbman can do the following:

1. Is there anyway to assign a user to a specific record. What I mean is I would like to set-up a database of user information. I would then like to assign a password so only a particular user can access and view their information to view (not modify).

2. How can I structure an OR search? If some one is searching for New York, NY 10087, is there a way to have the search pull up all results that match all criteria and also those results that are only New York OR NY OR 10087?

Thank you,
Michael

You have to modify the authorization configurations in the default.cfg file. Keep in mind that you can only assign records to userids, not passwords. Here are the configurations that you need to assign records to users:

(This is dependent on you assigning records to users, not allowing them to create their own account.)

1) Add a field "Userid" in the %db_def array:


Change the 18 to the appropriate number of field you have in this array.

2) Then modify the following authorization configuration settings:


Change the 18 to the number of field you have numbered for the Userid field.

THEN when you add records, you will have to input a userid for each record. THEN in the Admin Menu, you will have to add users and assign passwords to them.

One thing to elleviate hassle on your part is to activate the signup option, which allow users to create their own account. Then you can assign the registered users a combination of the following permissions:

1) Add
2) Delete
3) Modify
4) View

You will have to change the above authorization configuration settings to allow people to signup for an account.

With regards to the OR for searching...It is virtually impossible at this time. DBMAN is NOT set-up for Boolean search options (AND - OR). May be in a future release this will become available.

Hope this helps.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited August 03, 1999).]

look at:

http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000539.html

------------------
JGU

Seems to me that question #2 was about searching in different fields.

City: New York
State: NY
Zip: 10087

If that's the case, all you have to do is check the "Match Any" box in the search options section of the search page.


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