Hi there,

I am creating a page that displays four fields in List Format from a DB; (Date Logged, Log No., Problem & Status).

I would only like the four results displayed when the Status equals 'Open' and not where the Status equals 'Closed'.

I am using the following CDML below which seems to be working, however when the results are generated on the screen, it leaves a blank row for results where the Status equals 'Closed'.

Is there anyway to stop it from adding in the blank rows when the Status is 'Closed', as it becomes confusing to look at when there are lots of records and they span over multiple pages??

[FMP-record]

<TR>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-If:Status.eq.Open][FMP-field: DATE IN][/FMP-If]</TD>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-If:Status.eq.Open][FMP-field: Log No.][/FMP-If]</TD>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-If:Status.eq.Open][FMP-field: PROBLEM][/FMP-If]</TD>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-If:Status.eq.Open][FMP-field: Status][/FMP-If]</TD>

</TR>

[/FMP-record]

Thank you in advance for your help

Try this:

[FMP-Record][FMP-If:Status.eq.Open]<TR>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-field: DATE IN]</TD>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-field: Log No.]</TD>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-field: PROBLEM]</TD>

<TD ALIGN=LEFT VALIGN=TOP width=25% CLASS=Text10>[FMP-field: Status]</TD>

</TR>[/FMP-If]

[/FMP-record]

All the best.

Garry

I think I was going a bit overboard with the [FMP-IF] Tags!

Thank you very much for your quick solution, it worked a treat!