Seach Results - Online Guidebook

[Saxman]

Is there any way to add an option to choose how many search results one gets at a time? Maybe an option like some online stores; show 25 per page - 50 per page - show all. You could then print your results all at once instead of having to cut and paste into Word.

[Paul3eb]

is it possible to search by wall and get results per wall? for instance, if i were looking for "show me all walls that have two star or three star 5.11 to 5.13 and always stays dry"?

[Yasmeen]

Saxman, that's a cool idea - I'll work on that this week.

Paul3eb, do you mean that you want your results sorted by wall? At http://www.redriverclimbing.com/RRCGuideV2/search.php you can specify the region you want to search, and details such as stars and grades. If there's something more that you want, let me know and I'll work on that this week, too.

[dah-le]

I was also wondering if there was a syntax to exclude R & X rated routes...I was looking to try and do a search like this:
"show me all routes 5.0 to 5.6 without an R or an X first sorted by wall then sorted by grade"

I assumed that I missed something in the syntax, but I couldn't find any documentation.

Thanks,
Dale

[Yasmeen]

dah-le, the "danger" field is an enum, and its values can be '' or 'R' or 'X'. I'm looking around the current search page and I don't think there's a way to search for danger or to search purely by SQL. If I put that in, would anyone use it? For instance, you could type into the text field that is currently there "select name from route where danger='X' limit 10;" or "select name from route where danger='' limit 10;" and check a box that says "Execute my SQL query" or something like that, and the page would just serve as a messenger between the MySQL DB and you - no manipulation of what you put in. If your SQL was faulty, you'd get an error message instead of results. Let me know if this sounds good, or if you'd rather I just add some functionality such that you could specify the danger of a route.

[der uber]

Also, it would be nice to search on routes that get a breeze, and ones that have snakes.
Oh yeah, also, I guess a height rating would be usefull to that person who is 5'2" recently.

[tomdarch]

From a user-interface point of view, it seems like the ideal would be to add a "Danger" category like the "Sun" or "Dryness" ones, with check boxes for 'Normal', 'R' and 'X'. How that would be implemented is way, way beyond me, though.

[Yasmeen]

Absolutely. There could be a keyword search on the comments section of the routes that would return all routes whose comments contain the words "snake" and "5'2"". That's going on the list, too, der uber. Thanks for your note in our little Comments/Suggestion box. I think I'll filter out words like "the" and "a", a la Google.

I like the way you think, Tom. Anything that is stored in the database shouldn't be too hard to query via the search page.

[dah-le]

Yasmeen,
Yep, I like Tom's idea of the checkboxes as well...definitely beats trying to parse some sort of text string that's for sure.
Thanks a ton for making this even more useful...its already really cool to be able to do a lot of searches & sort/filter/etc.
-Dale

[Cliff Heindel]

OK! so if this works i can search for death routes with snakes that stay wet? sweet.