HELP with -find tag.

[ibiubu]

/FMPro?-db=Answers.fp5&-Lay=Web&-format=surveystep1.html&-Op=eq&-Error=error.html&Combined=323&-find

This is finding the correct record in FM, but the -format HTML page is loading information from the wrong record. It should be showing information from the record whose field "Combined" matches 323. But it is showing information from the previous record whose field "Combined" matches 322.

It looks like my URL is correct, but I cant figure out why it is loading the information from the wrong record. Anyone have any tips?

Larry

[Garry Claridge]

Check for "Sun-Spots"

Can you re-index the database? Maybe some corruption!

Good Luck.

Garry

[ibiubu]

EEKS. I think the problem is with the tag FMP-IncludeField

If I search using the -RecID tag it works fine:

http://xx.xx.xx.xx/FMPro?-db=Answers.fp5&-Lay=Web&-format=surveystep1.html&-Op=eq&-Error=surveyerror.html&-RecID=34934&-find...

Web page includes FMP-IncludeField that pulls the the contents of a field [fmp-include:surveystep1D3.txt]. This displays the correct .txt file.

But if I replace -RecID with a specific field called "CurrentID" it does not work:

http://xx.xx.xx.xx/FMPro?-db=Answers.fp5&-Lay=Web&-format=surveystep1.html&-Op=eq&-Error=surveyerror.html&CurrentID=32978&-find

The FMP-IncludeFiled is actually is finding data from the first record in the database, thus displaying the wrong .txt file. I cant get the tag FMP-Field to display the information from the correct record.

It has me stumped.

Larry

[Garry Claridge]

If I get a chance later today I will some testing on my system.

All the best.

Garry