ibiubu Posted December 26, 2004 Posted December 26, 2004 What is the best way to have a URL that will find multiple records? I know haw to use one for a single record search by including items such as: [FMP-Field:e1]=2&[FMP-Field:e2]=229&[FMP-Field:e3]=3344 But how would I do a search for 3 different records where: 1) All 3 records have [FMP-Field:e2]=229&[FMP-Field:e3]=3344. This is the same for all 3 records. 2) Each of the 3 records has different criteria for [FMP-Field:e1]= for example, [FMP-Field:e1]=1 and [FMP-Field:e1]=3 and [FMP-Field:e1]=5 Larry
aaa Posted December 27, 2004 Posted December 27, 2004 In FM6 You can find records for [FMP-Field:e2]=229&[FMP-Field:e3]=3344 Then sort by [FMP-Field:e1] Then export records to other file with "summary by" option Then you can see your foundset in new file.
ibiubu Posted December 27, 2004 Author Posted December 27, 2004 Good suggestion. Is there a way to do this that does not include exporting and manually finding the records in question? I want only the records in question to be displayed in the web browser: In other words, I could include [FMP-Field:e1]=1...3&[FMP-Field:e2]=229&[FMP-Field:e3]=3344 This would find 3 records for e1. But what if I want to find 3 records that were not 1...3 but were more like e1=1 and e1=3 and e1=5? Larry
Garry Claridge Posted December 27, 2004 Posted December 27, 2004 Larry, You can use a "-lop=or&e1=1&e1=3&e1=5" or you can use "-lop=or&e1=1 3 5". However, be aware that you cannot mix your "-lop" the whole URL will either be "or" or "and" To achieve a mixture you will need to use an [FMP-If] in the Format file. All the best. Garry
Recommended Posts
This topic is 7263 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now