if there is a value in a search field?

May 31, 200322 yr

I am trying to determine if a search field on a form has a value after it is submited.

I have used:

[FMP-If: TicketN .gt. 0 ]

this does not seam to do it.

May 31, 200322 yr

",,,a search field on a form has a value after..."

Not quite following what you are trying to accomplish. If the search won't happen without something in that field, then you should get an error if the field was empty. If a search is being performed on multiple fields, but a client is able to leave one of those fields blank and still perform the search, is that what you desire? If not, control the client input with JavaScript.

If you are trying to display certain data based on a field containing a data bit or being empty, you may want to use .cn.

If you are trying to dispaly certain data based on a field containing a specific value you may want to use .eq. or .neq.

If you are just curious about what data is being submitted for the search then you can go to the db file and select "Modify Last Find".

May 31, 200322 yr

Author

if one (ticket #) of the four search fields has a value in it, the I will display the results different from any other search combination.

so if ticket# is gt zero... resultA, else resultB

May 31, 200322 yr

"I have used:

[FMP-If: TicketN .gt. 0 ]"

If there are four search fields, they cannot all be named TicketN.

See your CDMLRD under the Replacement tag [FMP-If], and for help with this syntax look for "Text or numeric comparisons depending on field type" under "First parameter...".