Find not Finding

[Chuck]

I've got two database files involved with this problem. There's CClogin.fp5 which holds the user names and passwords for people who can log into the system. People log in with a form that has two fields on it, Username and Password, both with a -Op hidden input tag that is set to .eq.

Logging is works fine. Each login record has a field called CarrierID. On the format page that people are brought to when they successfully log in has a linked called Browse Claims that has the following link:

FMPro?-DB=CCclaims.fp5&-Lay=web&-Format=claim_list.htm&-Error=browse_error.htm&-Op=eq&CarrierID=[FMP-Field:CarrierID]&-Max=25&-Find

So, I log in as user X, who has CAR102 as his CarrierID field. When I get to the main.htm page (the result page for the login search), the link is successfully changed to

FMPro?-DB=CCclaims.fp5&-Lay=web&-Format=claim_list.htm&-Error=browse_error.htm&-Op=eq&CarrierID=CAR102&-Max=25&-Find

CCclaims.fp5 is definately the name of the file I want to search. There is a layout on it called "web" that has the CarrierID field on it. claim_list.htm exists, as well as browse_error.htm. If I go to the web layout in CCclaims.fp5 and perform a find within FileMaker for the CarrierID being CAR102, I get 1 record found. However, if I click the link, I get the browse_error.htm page with 401 being reported as the FMP-CurrentError, which means that no records were found.

??!!??

If after clicking the link I go into FileMaker, it seems to have never performed the find (pressing Cmd-R brings up no last find criteria).

If I change the link to find all records instead, like this:

FMPro?-DB=CCclaims.fp5&-Lay=web&-Format=claim_list.htm&-Error=browse_error.htm&-FindAll

Then FileMaker does do the find. I create a found set of 1 record before clicking the link and have all records found after clicking the link.

In claim_list.htm is the following code:

[FMP-RECORD]

<P>Here's a record. Carrier ID is [FMP-FIELD: CarrierID].</P>

<P>

[/FMP-RECORD]

Doing the -FindAll link shows four lines for each of the four records in the database. Each line says "Here's a record. Carrier ID is ." In other words, none of the data from the database is being fed to the web page.

Any suggestions or assistance would be greatly appreciated.

Thanks,

Chuck

[Vaughan]

Is the field on the layoutspecified by the -lay tag?

[seanc]

I don't know if it would help, but you could get rid of some of the redundant code in the link and see if anything changes.

-error is optional, and you will get an error number if there is a problem, which you might not be seeing with your error page.

-op is (I think) optional and not necessary here

-max is (definitely) optional, and default is 25 anyway.

Simplify as much as possible!

Cheers,

Sean.