December 26, 200421 yr 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
December 27, 200421 yr 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.
December 27, 200421 yr Author 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
December 27, 200421 yr 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
Create an account or sign in to comment