How to use the value in a valuelist in an if statement?

[lzeng]

Hi:

I want to use a value in a valuelist to decide whether or not show a record in a result page. Say: I have a valuelist "Room_Booked", the values in it are "Yes" and "No". I want to show the records with "No" in "Room_Booked". I used:

code:

---

[FMP-If: Room_Booked.eq.No]

[FMP-Record]

...

[/FMP-Record]

[/FMP-If]

It didn't work, how should I deal with it?

Thanks in advance!

Catty

[Jeff Spall]

Hi, I can't see anything wrong with that reasoning.

here's one from our own room booking system:

[FMP-IF: availableam.eq.available]

[FMP-INCLUDE: am.txt][FMP-ELSE]

[FMP-INCLUDE: blank.txt]

[/FMP-IF]

you can substitute

[FMP-Record]

.fields and portals and stuff..

[/FMP-Record]

for the includes, no problem.

Can I suggest a troubleshooting test?

Split up the code.

Have the records display on their own, and just try:

[FMP-If: Room_Booked.eq.No]

---working OK---

[/FMP-If]

If they both work, you can put the code back together, if they don't you'll know where the problem lies

regards, jeff

[lzeng]

Thanks Jeff!

I got it! I did like this:

code:

---

[FMP-Record]

[FMP-if: Room_booked.eq.No]

...

[/FMP-if]

[/FMP-Record]

Catty