FMP-If .and. question

[mortemar]

Hi there,

I got a little problem bothering me for a while now, I've tried everything to fix it, but I'm still stuck, need help please !

Here goes, in my result file I need to simply check if the value in a field is equal to a certain value, an example will be easier :

[FMP-If: Field: etablissement.cn.Centrale des Syndicats (CDS)]

As you can see, my value is composed of multiple words, so I tried to fix everything using this form

[FMP-If: (Field: etablissement.cn.Centrale) .and.(Field: etablissement.cn.Syndicats).and.(Field: etablissement.cn.(CDS))]

Problem is, even if the value in the field and my literal value match, my If rejects the value.

Am I doing something wrong ?

Funny thing is that for a 2 word literal value, it does work !

Hope someone's going to be able to help me.

Thx a lot,

Jerry

[Unable]

Hi Jerry,

Instead of

[FMP-If: Field: etablissement.cn.Centrale des Syndicats (CDS)]

try

[FMP-If: etablissement.cn.Centrale des Syndicats (CDS)]

Best of luck.

[mortemar]

Thx a lot for the suggestion, I didn't know that the "Field:" was optionnal

But actually my problem was of a different nature, I didn't think about the latin accented characters, I tried to substitue an "

[Jeff Spall]

Hi, the syntax for fields in an 'If' is very badly documented

Filemaker expects:

field.operator.literal_text

in an 'If'. It ignores word spaces.

to use a field as the last part, the syntax is:

[FMP-If:myfield1.op.Field:myfield2]

i think that:

[FMP-If:myfield.op.{FMP-Field:myfield2}]

does not work

regards, jeff

[mortemar]

Thx Jeff,

I actually found out how to make things work, for example, if I need to do a search on a student supervisor and say the year of the obtention of the diploma, I just build my results.htm file like this :

[FMP-If: (Field:direction.cn.name).and.(Field:direction.cn.surname).and.(Field:Depot_final_ann.cn.1992)]

and it works great.

So thx for your suggestion, it was the good one

Jerry