dburgwin Posted May 24, 2003 Posted May 24, 2003 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 Posted May 26, 2003 Author Posted May 26, 2003 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
Recommended Posts
This topic is 7953 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now