Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 23

Thread: Macro for Know Your Local Maine Cacher Challenge 2010

  1. #11
    Join Date
    Jun 2004
    Location
    Bangor, ME
    Posts
    6,061

    Default

    Quote Originally Posted by cano View Post
    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.
    DNFTT! DNFTT! DNFTT!

    "The funniest thing about this particular signature is that by the time you realize it doesn't say anything it's to late to stop reading it..."

  2. #12
    Join Date
    Dec 2009
    Location
    A, A
    Posts
    331

    Default

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

  3. #13
    Join Date
    Dec 2009
    Location
    A, A
    Posts
    331

    Default

    Quote Originally Posted by dufzor View Post
    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?

  4. #14
    Join Date
    Jun 2004
    Location
    Bangor, ME
    Posts
    6,061

    Default

    Quote Originally Posted by dufzor View Post
    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...
    DNFTT! DNFTT! DNFTT!

    "The funniest thing about this particular signature is that by the time you realize it doesn't say anything it's to late to stop reading it..."

  5. #15
    Join Date
    Jun 2004
    Location
    Bangor, ME
    Posts
    6,061

    Default

    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.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	gsak_knowme.JPG 
Views:	36 
Size:	373.2 KB 
ID:	1007  
    DNFTT! DNFTT! DNFTT!

    "The funniest thing about this particular signature is that by the time you realize it doesn't say anything it's to late to stop reading it..."

  6. #16
    Join Date
    Jun 2004
    Location
    Bangor, ME
    Posts
    6,061

    Default

    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
    Last edited by brdad; 07-25-2011 at 07:55 PM.
    DNFTT! DNFTT! DNFTT!

    "The funniest thing about this particular signature is that by the time you realize it doesn't say anything it's to late to stop reading it..."

  7. #17
    Join Date
    Jun 2004
    Location
    Bangor, ME
    Posts
    6,061

    Default

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

    "The funniest thing about this particular signature is that by the time you realize it doesn't say anything it's to late to stop reading it..."

  8. #18
    Join Date
    Aug 2008
    Location
    America
    Posts
    2,544

    Default

    I had no idea this was going to cause such a commotion.
    I have no enemies, but I'm intensely disliked by my friends.

  9. #19
    Join Date
    Dec 2009
    Location
    A, A
    Posts
    331

    Default

    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

  10. #20
    Join Date
    Jun 2004
    Location
    Bangor, ME
    Posts
    6,061

    Default

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

    "The funniest thing about this particular signature is that by the time you realize it doesn't say anything it's to late to stop reading it..."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •