Re: [mapguide-users] Mapguide 2.5.2 fdo expression IF with a string field

2017-05-18 Thread Rémy Gourrat
Thanks It's the right way. Rémy ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users

Re: [mapguide-users] Mapguide 2.5.2 fdo expression IF with a string field

2017-05-18 Thread Jackie Ng
You could try using LOOKUP() as a workaround. This should be equivalent to what you're trying to achieve. LOOKUP(FIELD1, 'No', 'A', 'Yes') LOOKUP(FIELD1, '1', 'A', 'Yes') - Jackie -- View this message in context:

[mapguide-users] Mapguide 2.5.2 fdo expression IF with a string field

2017-05-17 Thread Rémy Gourrat
Hi, If i use the FDO expression with a number field like this => IF('FIELD1 = 1','Yes!','No') it's Ok But I don't know how to escape the quote character when I want to use it with a string field, I tried it without success : IF('FIELD1 = \'A\'','Yes!','No') IF('FIELD1 = ''1''','Yes!','No')