web 2.0, frontend, ajax, flash, css, dhtml, php

During that process, I had to get Median values out of it. With oracle9 gettign median value is so easy. However, once I had to deal with oracle8 in the first stage of the development process and oracle8 didn’t have the built in function.

Anyways, here’s oracle 9 approach to get median value in basic form:

SELECT
percentile_cont(0.5) within group (order by a.”Setup Duration” ASC)
from
studysetup_metric;

See? It’s that simple.

One another thing I had to deal with was that string value passing from asp.net to oracle procedure. Actually it’s related to string length limitation in sql statement in oracle.(I’m not sure whether it applies to another sql..)

Usually string is passed from asp.net, it is stored in one of variables in oracle stored procedure. The variable is used in sql statement within the procedure. But the string length of the variable that is used in sql is limited to somewhere 255 as I recall(but I’m not 100% sure.. please look for the information on internet for accuracy). What if string values are longer than what’s supposed to be. In this case, you would want to use collection type instead. I’ll write this about collection type and where-in sometimes later…

to be continued…

This post is not related to technology or flash at all, but I thought this kind of post could be worthy to show.

——————————————————-

The following is the philosophy of Charles Schultz, the creator of the “Peanuts” comic strip. You don’t have to actually answer the questions. Just read the e-mail straight through, and you’ll get the point.

1. Name the five wealthiest people in the world.

2. Name the last five Heisman trophy winners.

3. Name the last five winners of the Miss America.

4. Name ten people who have won the Nobel or Pulitzer Prize.

5. Name the last half dozen Academy Award winner for best actor and actress.

6. Name the last decade’s worth of World Series winners.

How did you do?

The point is, none of us remember the headliners of yesterday. These are no second-rate achievers. They are the best in their fields. But the applause dies. Awards tarnish. Achievements are forgotten. Accolades and certificates are buried with their owners.

*Here’s another quiz. See how you do on this one:*

1. List a few teachers who aided your journey through school.

2. Name three friends who have helped you through a difficult time.

3. Name five people who have taught you something worthwhile.

4. Think of a few people who have made you feel appreciated and special.

5. Think of five people you enjoy spending time with.

Easier?

The lesson: The people who make a difference in your life are not the ones with the most credentials, the most money, or the most awards. They are the ones that care.

“Don’t worry about the world coming to an end today. It’s already tomorrow in Australia.” (Charles Schultz)

Here is another webclient application using Ajax.

“http://www.roundcube.net/”:http://www.roundcube.net/

This blows away current gmail and once-attempted-flash-client-webmail application. That is great to see RIA starting to appear. For web application like that, AJax fits to the category as a proper technology. Why is it good(better)? My reason is obvious.

PERFORMANCE!
Read more

Macromedia released a note that Flex2 and Flash player 8.5 are on the horizon. In the summary of what they released:

Flash player 8.5 – ActionScript 3!!! with ECMAScript specifications.

Flex Framework 2 – not sure what’s included

Flex Builder 2 – previsouly code-named Zorn. For those who don’t have background of this Zorn, this IDE is based on Eclipse.

Note that all new product line will be available sometime first half of 2006.

“Read more?”:http://www.macromedia.com/macromedia/proom/pr/2005/announcing_flex2.html