Date:  07/12/2007 01:32:28 PM Msg ID:  003454
From:  Ali Koumaiha Thread:  003453
Subject:  Re: I need to apply rights by provider ...
Why not:
And IPTC200 = 'USA' && OR WHATEVER COUNTRY CODE THAT IS?

Then only USA comes up.

or even better, Have a table of the following:
PhotoPermTable.dbf
PhotoID, CountryGroupID

Another Table
CountryCodePerm.dbf
CountryGroupID, Country

Example:
Table1
PhotoID = PHOTO1.JPG 
CountryGroupID = USASPAIN

Table2 (group persmission)
CountryGroupID=USASPAIN
Country=USA
CountryGroupID=USASPAIN
Country=SPAIN.

Then, when you're viewing the photo, you have the country of the user, just do a right join with the CountryGroupPerm table  and your key is the CountryGroupID.

I hope that makes some sense.


Sent by David Flores on 07/11/2007 01:55:08 AM:
I´ve been having problems with the rights applied to photos; for example, I need a photo must be seen in USA, but not in Mexico and not in England and not in France; and need someones must be seen just in Spain ..... the case is that I´ve using this: "(IPTC200 CONTAINS(T_BE_HO)) OR (IPTC200 CONTAINS(T_IT_FR_UK_AL_US)) OR (IPTC200 CONTAINS(T_ES)) AND NOT (IPTC200 CONTAINS(S_ES)) OR NOT (IPTC200 CONTAINS(S_ES_LA_BR_AR_ME)) OR NOT (IPTC200 CONTAINS(S_ES_PO_LA_BR_AR_ME)) OR NOT (IPTC200 CONTAINS(S_ES_PO_LA_RU_BR_AR_ME))  OR NOT (IPTC200 CONTAINS(S_ES_RU_LA_BR_AR_ME)) OR NOT (IPTC200 CONTAINS(S_ES_ME))".    It´s difficult to keep balance and organized this ....
Is there anyone that is using a Database file to keep this organized by rights? ....   - Really Thank you.
DF