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