Online guidebook

Kwas · Post by **Kwas** » Mon Nov 25, 2002 5:43 pm

I would like to here what Todd Skinner has to say about the impact his millitant actions had at Hueco Tanks?

Post by **Horatio Felacio** » Mon Nov 25, 2002 7:14 pm

what were his militant actions?

as far as i can tell, hueco is way better than it used to be. no crowds and climb anything in the park except one boulder with two good problems on it.

Post by **Bruno** » Mon Nov 25, 2002 7:44 pm

Very cool database.
One small bug is that when you sort by number grade it thinks that 5.2 through 5.9 come after 5.13. I assume it's sorting alphabetically instead of numerically.

It would also be nice if the wall the route is on was listed.

Awesome job. Thanks for providing it.

ray · Post by **ray** » Mon Nov 25, 2002 7:52 pm

Yea Bruno, I plan on taking care of that bug. It's strange because only in climbing does it make sense for 5.12 to be greater than 5.2.
Someone suggested just storing the grades without the "5." then it will sort correctly. I'll definitely take care of that.

I'm working on getting the wall linked to the route also. Currently it's the wall_id that's in the route table. I want to link to that to show the wall_name also so it makes more sense.

Kwas, what are you saying?

ray · Post by **ray** » Mon Nov 25, 2002 8:02 pm

What happened with Skinner and Hueco?

Post by **deleted username** » Mon Nov 25, 2002 9:52 pm

I was just playing with the online guidebook and must say that it's an internet savvy climbers wet dream. Way to go ray. Sorry I didn't say that when I was arguing about your inclusion of new routes, but I do think this type of thing is the wave of the future and I applaud it as an undertaking.

Post by **Danny** » Tue Nov 26, 2002 12:16 am

ray if you don't want to get rid of the 5. you can probably do something like "order by substring(grade,3)" which will get rid of 5. only for sorting.

do you know how to join tables yet?

select bla1, bla2 ... wall_name ... blaN from route_table left join wall_table using (wall_id)

Post by **deleted username** » Tue Nov 26, 2002 12:51 am

Damny, I definately disagree with you posting sensitive programming crap to this website. It gives other non-climber groups further evidence that climbers are just the chess club and dungeons and dragons nerds that they picked on in high school. We're doomed.

Post by **no grain** » Tue Nov 26, 2002 1:56 am

"I can't believe what a bunch of nerds we are, looking up money laundering in the dictionary!"

Post by **Horatio Felacio** » Tue Nov 26, 2002 3:36 am

so really...what has the rrgcc done to help the FS approval system? not trying to pick a fight (yet, anyway), but i'm just wondering what they've done? does no response mean nothing?