CDML Search URL question

[dburgwin]

Hi,

I have a Field, "Status" which has two radio buttons, "accepted" and "not accepted." When records are added to the database neither option is selected. I then go through the submitted records and click one or the other. I was wondering if there is a way to select the records with an empty field (with neither "accepted" nor "not accepted" selected) in a CDML URL so I can show all of the new records in a display page. I thought I could use:

&Status=""

Where the empty double quotes would act as a null value. This has worked for me in a pop-up menu in the past. Will I have to use an FMP-IF statement to accomplish this? Below, I have included an URL which works in another situation. The only thing I would like to change is the "&Status=yes" part.

FMPro?-DB=CSMLCalendar.fp5&-Format=calresults2.html&Status=yes&CurrentDateTest=0&-SortField=Month&-SortOrder=descending&-Sortfield=Day&-Sortfield=Year&-max=5&-Find

Thanks,

Darryl

[dburgwin]

Hi,

Found the answer in another thread (create another calculation field in the DB which determines if the field in question is empty or not and use this field in the Search string).

Darryl