Empty field find

[shai1]

This may sound like a dumb question, but how do I do a search for all the records that have a field with no data? Everytime I've tried it I don't get the results I want. I used the example below to find all records with no page number. Can anyone see what I did wrong?

"FMPro?-DB=Tracking.FP5&-Format=summary.htm&-Op=eq&ProjectName=[FMP-Cookie : theProject]&-Op=eg&PageNumber=&-Max=all&-Find"

Thanks for your help!

Dave

[Garry Claridge]

Try this:

"FMPro?-DB=Tracking.FP5&-Format=summary.htm&-Op=eq&ProjectName=[FMP-Cookie : theProject]&-Op=eq&PageNumber==&-Max=all&-Find"

I have changed:

-op=eg to -op=eq

PageNumber=& to PageNumber==&

Hope this helps.

Garry

[shai1]

actually the "eg" was a typo, I did have "eq". I've also tried the "==" that didn't work either. Any other ideas?

[Garry Claridge]

Is the page containing this URL being processed by FM?

If not the [FMP-Cookie: tag will not be replaced by the cookie contents. Hence, the search will be looking for Projects with the name "[FMP-Cookie: ....". You can check this going to FM and select "Modify Last Find" from the "Records" menu.

Other than that the URL should work. Test it without the "&ProjectName=[FMP-Cookie : theProject]&".

All the best.

Garry

[Jeff Spall]

quote:

---

but how do I do a search for all the records that have a field with no data?

---

Hi, the easiest way to do this is to create another calculation field in your database, like:

If(IsEmpty(PageNumber),"yes","")

then do a search on that field for "yes":

"FMPro?-DB=Tracking.FP5&-Format=summary.htm&-Op=eq&ProjectName=[FMP-Cookie : theProject]&-Op=eq&calcfield=yes&-Max=all&-Find"

....I usually fix problems by going around them

regards, jeff