Macro for Know Your Local Maine Cacher Challenge 2010

Quote:

---

Originally Posted by cano

I looked at your SQL statement. You must use aggregate function on columns not included in GROUP BY.

---

Must or should? I think it's working. :p:p

Thanks Brdad, installing it now and will give it a whirl.

Quote:

---

Originally Posted by dufzor

Thanks Brdad, installing it now and will give it a whirl.

---

I've run it multiple times and it has pulled up cachers that have lost of placements, but only 1 or 2 types of caches, not the three different kinds. Am I missing something?

Quote:

---

Originally Posted by dufzor

I've run it multiple times and it has pulled up cachers that have lost of placements, but only 1 or 2 types of caches, not the three different kinds. Am I missing something?

---

It should be only showing hiders who have hidden 3 or more types. I will double check...

It only shows owners with 3 or more cache types on mine, here is what my screenshot looks like. If you have a database of all Maine caches, it should look similar.

The only way I can think it would revert to showing owners with less than three is if there are none in your database (or it's having trouble finding them). I've edited the macro to Send a warning message Cannot find any hiders hiding 3 different types of caches! if that is the case. Try this update:

EDIT: Deleted Old version

Has anyone else tried this macro and had good or bad results?
Did this new version give you an error message Dufzor?

I had no idea this was going to cause such a commotion.

Tried it again. Works until I tell it to remove the benchmarks and waypoints, then it just gives me everything but them, even if a cacher has only placed one kind of cache, its in the list. However, I can deal with that and ignore the waypoints. Thanks Brdad

Ah, I think I can fix that. But it might be a day or two....