Limit number of rows in an oracle query
select *
from (
select *
from (select * from CODETABLE_READCODE)
order by DESCRIPTION
)
where rownum <= 6
{ Monthly Archives }
select *
from (
select *
from (select * from CODETABLE_READCODE)
order by DESCRIPTION
)
where rownum <= 6
Well i needed to know how to generate a schema from XSLT which means you need to output the first line of the schema definition which wasnt too intuitive so here is the result:
hmmm – cant paste it in here – see attatched file!!
XSLT Transformation to Generate an XSD schema
Ok it was MUCH simpler than i thought of course! you simply type in the whole thing into the xslt and it just prints it out! so you dont need to use xs element at all doh!
Well we recently did a wee trip to the bay as part of what was supposed to be Amanda an I’s big trip down south. hmmm … anyway twas coool.
The pictures are here :
heres a taste:
I did quite a bit of top roping (no leading infact:) but climbed some harder stuff which was cool. We met and excellent guy Danny who is in the picutre above leading a 23 so he led up a lot of stuff and i followed:)
The guidebook to get is by len gillman. Theres also a website:
which has a picture the same as mine of Tibia on it!:)
Routes (in order of climbing – all on a tope rope im afraid):
Day1 (The Plateau):
Day 2 (Whekenui):
Day 3 (Sunshine Buttress):
Sunshine Butresss was a nice relaxing day after the climbing the day before. Needless to say Danny had left by then. Amanda also climbed the 15 in her tramping boots which was pretty funny – infact i think she climbed harder in them than in rock shoes… wierd.
We also met Mere who is the caretaker of the bay for the Marae there who is lovelly and mentioned that she had been visited by the “Iraelites” (Danny and his girlfriend Shelly are from Isreal).
Good work. Returning home on sat night in time to do some college work on sunday. Amanda and Dave headed off to Titahi bay for more climbing (addicts).
Have found the ultimate web calendar:
Thyme :
this is now installed at :
but you wont be able to look at it yet as ive not set up a guest user:)
anyway i can synchronise with iCal, and various other calendar programs. sweeet!
so i can keep my main ical on my powerbook as the publisher and subscribe from anywhere else. unfortunatley it doenst do 2 way subscribe so i can add events in other places but i can have a special calendar on the web for that which i then subscribe to on my computer.