+Borgt Posted January 4, 2003 Share Posted January 4, 2003 How can I get a query to return all locationless caches? If I'm not mistaken, there are only about 300 of them, so the number of results is not a problem at this time. The problem I seem to have is in the location. I can't get the distance field greater than 500 miles from any given point. It appears the locationless caches use the coordinates originally entered when the cache was created. Link to comment
+Sissy-n-CR Posted January 4, 2003 Share Posted January 4, 2003 I looked briefly for the solution, it's here somewhere, but... It takes two queries. On one of your queries on the From origin select Countries and in the dropdown, select the top country, scroll to the bottom, hold down the SHIFT key while selecting the bottom country. This selects all countries. Finish filling our your query and submit. Do the same thing on the other query, but select States and all of the States this time. You'll get two queries with all of the locationless caches. Hope this helps. CR Link to comment
+Sissy-n-CR Posted January 4, 2003 Share Posted January 4, 2003 You know, this brings up a point. A file with all of the Locationless waypoints would only change seldom and really is not needed. An eBook of the locationless really doesn't need the last logs and that wouldn't change very often. Why not put up a link to these two files to be downloaded directly. Change the file once daily if needed. You don't get queries any more often than that anyway. It's save query time on the server (I think) and not take up two queries on the user's end. Thoughts? CR Link to comment
+Sissy-n-CR Posted January 4, 2003 Share Posted January 4, 2003 You know, if somebody put The United States on the dropdown for Countries, it'd only take one query. (hint, hint, wink, wink) CR Link to comment
+Borgt Posted January 5, 2003 Author Share Posted January 5, 2003 Thanks CR for the solution. I was hoping I could do it with one query, but it looks like for now it'll have to be 2. I like your suggestion! I hope it will be looked at and seriously considered by TPTB. Link to comment
+parkrrrr Posted January 16, 2003 Share Posted January 16, 2003 quote:Originally posted by Sissy-n-CR:You know, if _some_body put The United States on the dropdown for Countries, it'd only take one query. Oh, what the heck, I'll go ahead and mention it: that somebody doesn't have to be an admin, if you have any skill with HTML. "United States" should have a value of 3 (that value was stolen from the "hide a cache" form.) You'll also have to change the form to have a non-relative URL. For now anyway, it works and it creates a query that returns all of the locationless in one big file. (And without the duplication you get in the two-query method.) Link to comment
+fizzymagic Posted January 16, 2003 Share Posted January 16, 2003 quote:Originally posted by Warm Fuzzies - Fuzzy:You'll also have to change the form to have a non-relative URL. I think it's easier and safer to use <Base href=...> in the <head> section. Link to comment
+Sissy-n-CR Posted January 17, 2003 Share Posted January 17, 2003 quote:Originally posted by Warm Fuzzies - Fuzzy: quote:Originally posted by Sissy-n-CR:You know, if _some_body put The United States on the dropdown for Countries, it'd only take one query. Oh, what the heck, I'll go ahead and mention it: that _some_body doesn't have to be an admin, if you have any skill with HTML. "United States" should have a value of 3 (that value was stolen from the "hide a cache" form.) You'll also have to change the form to have a non-relative URL. For now anyway, it works and it creates a query that returns all of the locationless in one big file. (And without the duplication you get in the two-query method.) http://216.202.195.127/warm.gif You know, I had thought about doing that--I've done that in the past on threaded forums to allow myself longer message headers--but I was a little timid. I certainly didn't want to screw something up. Plus, I didn't know which value to use. (You sure it's 3? I show that for Australia.) Just re-read you post and then looked at the "hide-a-cache" page. I had been looking on the query page, didn't think to look on the hide-a-cache page. US is 2, not 3. Gonna try that right now. Thanks! CR Link to comment
+parkrrrr Posted January 17, 2003 Share Posted January 17, 2003 quote:Originally posted by Sissy-n-CR:something up. Plus, I didn't know which value to use. (You sure it's 3? I show that for Australia.) Just re-read you post and then looked at the "hide-a-cache" page. I had been looking on the query page, didn't think to look on the hide-a-cache page. US is 2, not 3. Yep, you're absolutely right, it is 2. That's what I have in my local copy of the pocket query form, so it must be right because it worked. I pulled the number out of my sometimes-faulty memory without checking first. Guess that's what I get for not checking my facts. Ah, well, that's why I mentioned where I got the value from, so people could check up on me. Link to comment
+Sissy-n-CR Posted January 17, 2003 Share Posted January 17, 2003 quote:Originally posted by Warm Fuzzies - Fuzzy:...of my sometimes-faulty memory ... So, you're saying it was a little "fuzzy?" Couldn't resist! CR Link to comment
Recommended Posts