Eyi’s Personal Blog

Someone Cares

Verse:

Someone cares and always will

The world forgets you but God loves you still

You can not go beyond His love

No matter what your guilty of

He always loves you

He really loves you

Verse:

He knows you pain and all your loneliness

His watchful eyes know every path you’ve made

You can not go beyond His love

No matter what your guilty of

He will do miracle for you right here right now

Chorus:

His love is tender to mend a broken heart

Cast down your worries and He will set you free

He’s more than able to make your life a new

Someone cares, Jesus cares for you

What a good song it is. It’s a song that has a special meaning and unforgettable memory for me. A couple days ago, I was finding songs that I’d like to sing in Youth Fellowship Saturday night. When I scrolled down my mouse wheel in Easy Worship, I found a lot of songs and at last I stopped at this song. When I saw this song, my mind took my memory to a couple years ago when I heard this song for the first time. This song was sung in Youth KKR and I was really touched by that song. Besides, this song was sung by someone who was special for me. What a great lyric to show how Jesus loves you so much. He loves and always loves you no matter what your guilty of. His love is tender to mend a broken heart.

If there are some data of Products, and OrderDetails.

Products

OrderDetails

If you needed to try this sample application, just create those table in your database.

Products

ProductId Number, ProductName Text(40)

OrderDetails

ProductId Number, TotalQuantity Number

Arrange products quantity chart that consist of data from those tables!

First of all, you need to join the table to get productid and productname from Products, and then totalquantity from OrderDetails. Here is the query:

Select a.productid,a.productname,sum(b.totalquantity) as totalquantity

From products as a inner join orderdetails as b

on a.productid = b.productid

Group by a.productid,a.productname

Order by a.productid

Here is the result of query execution:

If you want to make an application that contains chart in it, create a project in Microsoft Visual Basic 6.0, add Microsoft Chart Control 6.0 to your project, and drag drop the component into your form.

Create this code to your form:

Dim Cn As ADODB.Connection

Dim Rs As ADODB.Recordset

Private Sub Form_Load()

Set Cn = New ADODB.Connection

Cn.ConnectionTimeout = 30

Cn.CommandTimeout = 0

Cn.ConnectionString = “Provider=Microsoft.Jet.Oledb.4.0;” & _

“Data Source=” & App.Path & “\Northwind.mdb;” & _

“Jet Oledb:Database password=”;”

Cn.CursorLocation = adUseClient

Cn.Open

Set Rs = New ADODB.Recordset

Rs.Open “Select a.productid,a.productname,sum(b.totalquantity) As

totalquantity From products as a inner join orderdetails as b on

a.productid = b.productid Group by a.productid,a.productname Order by

a.productid”, Cn

If Not Rs.EOF Then

MSChart1.ColumnCount = 1

MSChart1.ColumnLabel = “Product Name”

MSChart1.RowCount = Rs.RecordCount

MSChart1.Column = 1

Dim i As Integer

i = 1

Do While Not Rs.EOF

MSChart1.Row = i

MSChart1.RowLabel = Rs(”productname”)

MSChart1.Data = Rs(”totalquantity”)

i = i + 1

Rs.MoveNext

Loop

End If

Rs.Close

Set Rs = Nothing

If Not Cn Is Nothing Then

Cn.Close

Set Cn = Nothing

End If

End Sub

Here is the result of chart:

Everyone that watched the F1 Final Race last night must feel the tense of the race. The race is held at Interlagos Circuit Brasil, and this race is the closing race of 2008 F1 season. The race remains the competition of Lewis Hamilton and Luis Felipe Massa, who got the only chance to be the F1 World Champion. Before the race, Hamilton wins 7 points over Massa, which means that Hamilton will just have to finish the last race in fifth position to win the F1 World Champion. It seems so right when the third day of qualification, Massa gets the pole position while Hamilton in the fourth position. This condition gives advantage to Hamilton if he can maintain his fourth place till the race finished.

When the race begins with Massa at the pole position, nothing is excited to watch because Massa is very superior in the first position. No one can past him before he drives his car to pit. The exciting moment is happen in the last 5 laps to finish. The rain started to fall, and some cars get into the pit to change their tyres to wet tyre.

As I can see at TV, almost all cars in the top 7 standing table get into the pit except Timo Glock from Toyota. The assumption that he didn’t get into the pit is the race remaining 5 laps to go. He hopes the he will be able to finish and maintain his position till finish with dry tyres, while hoping the shower won’t continue. After some drivers get into the pit, Massa is still leading the race while Hamilton in the fifth position, in front of Sebastian Vettel from STR. Sebastian Vettel comes into the greatest challenging contender in this race. After challenging Kimi Raikonnen in some laps before, then he comes to challenge Hamilton after changing his tyres to wet. Unfortunately for Hamilton, Vettel past him in just 2 laps remaining, which means that Hamilton loses his fifth position. Losing the fifth position means the losing of F1 World Champion. From the team radio, the team told Hamilton that he must past Vettel or Glock. It seems so difficult because Vettel’s car is a little bit quicker than Hamilton’s car, while there is a quite far gap between Hamilton and Glock, 15 seconds clear. It must be tough to be Hamilton that time. As I watched that time, the Ferrari team seemed to celebrate the losing fifth position of Hamilton. The atmosphere becomes more cheerfully in Ferrari’s garage while Massa finished his race in the first podium, instead the McLaren’s garage everyone seemed so scared and hope some miracles happen.

The miracle finally happens just a couple turns to finish. Timo Glock who had decided not to change his tyres to wet, seems slower and slower in his last lap. This condition makes Vettel and Hamilton who competing for fourth and fifth position can past him easily. This situation must be the most dramatic moment for Hamilton, because he gets back his fifth position and make him able to be the F1 World Champion. When Hamilton past Glock, the commentators are very very surprised with this condition. One of them said “Ow, is that Glock, is that Glock going slowly..??” with surprise tone.

And the other one said, “It is Glock. Ow my Godness me..!! Hamilton backs his position again. A million, a hundred thousands local heart sink in the grandstand. It handed the place back to Hamilton. He comes through and absolutely I’m sure that he’s gonna claim fifth position, which is all he needs to do to become the 2008 Formula 1 World Champion.”. Then Hamilton finally finished his race in fifth position. The strange situation held in Ferrari’s and McLaren’s garage. Each of them claims that they win the World Champion. In fact, the Ferrari realize that they are at the losing side. Even the father of Massa has just realized that his son failed to win the World Champion when Hamilton crosses the finish line. “They celebrated a little bit too early”, that is what the commentator said.

Wow, all I can say is what a great final race. Even the commentators said in the end of race, “What can I say, I can’t say anything. I can’t really afford any words. Great, absolutely great, absolutely great, absolutely great.”. I agree with them, I think that was the greatest dramatic race ever. My heart beat so fast when Hamilton was behind Vettel, and had a long breath when he past Glock to get the fifth position. F1.com wrote that race as “A Nail Biting Finish”. Well, you can see the moment here: http://www.youtube.com/watch?v=0D63WnBwYWs.

The lesson that we can get from this race is:

Never give up

Can you imagine if Hamilton was give up on that race..?? One for sure, he won’t be able to be the F1 World Champion. He deserves to give up, because the situation is so uncomfortable, and depressed. It must be tough to be Hamilton that time, he must keep calm. He was in depressed and in tense while he was behind Vettel. He could be slip that time and the title goes to Massa. It must be tough to be Massa too. After failed to be the World Champion, he could still put his chin up and not yet given up too.

God will make a way when there seems to be no way

Who could predict that the decision of Timo Glock not to change his tyres will make a major impact to Hamilton and Massa? When Hamilton was behind Vettel, everyone must  be think that Massa will be the World Champion. But in fact, God used Timo Glock to break that and gives the title to Hamilton. Whenever you stuck, depressed, or other conditions that makes you crazy, just remember that “God will always make a way when there seems to be no way”.

God Bless..

* Irony, Massa is the winner (top of podium), Hamilton is the Champion (bottom of podium).

Hey..!!

Good news for all of you from Jawaban.Com. Get the daily devotional on your friendster profile by copy pasting the link from Jawaban.Com. Beside that, you can get iPod Shuffle for free, well, if you’re lucky for sure.. hehehe.. :p

Visit Jawaban.Com for more info.

Click here for the daily devotional options for your friendster profile or blog : http://www.jawaban.com/news/widget/

God bless,

3y1

For some football fans, John Terry is one of the famous football players in the world. He’s the Captain of both English and Chelsea. Everyone wants to be like him, he is rich, handsome, a great leader and tough guy on the field. But a few weeks ago at Moskow, he fell down on the field with full of guilty and tears. Why..?? Because he missed the penalty at Champions League Final that made his team Chelsea couldn’t win the trophy.

The victory was in front of Chelsea when John Terry took the penalty, if he scored that penalty, they would win the trophy. In fact, he failed and let Manchester United took the advantage to win. Chelsea wasn’t lose when John Terry failed to take the penalty, they lose when Nicolas Anelka failed to take the penalty. So I think that was not John Terry’s fault, I think it was Anelka’s fault. But we can’t blame them, because that’s football. There’s only one winner and one loser at the end.

I don’t know a lot about John Terry, but I’m sure that night made him so down. A tough guy, Captain, and leader fell down into deeply sadness and his eyes were full of tears. After that night, he didn’t want to talk to anybody and hard to get asleep. He said in Chelsea’s website that he had just slept a few hours and hope that night was just a nightmare.

A few days after the final, he wrote an open letter to Chelsea fans that posted in Chelsea’s website. Here is some quotes of the letter :

To all the Chelsea fans, all my team-mates, the manager and staff at the club. I’m so sorry for missing the penalty and denying you the fans, my team-mates, family and friends the chance to become European Champions.

Many people have told me I don’t need to say that but I feel I need to, that’s just me. I have relived that moment every minute since it happened. I have only slept a few hours and wake up every time hoping it’s all been a bad dream.

I have had some amazing support from fans, current and ex-players, family and friends and I need to thank everyone  for that. But I am a big man and I take responsibility for us not winning.

Well, actually I’m not a Chelsea’s fans, instead I’m an MU’s fans. I’m glad that MU success to win the Champions League trophy, but I got a lot of concerns to Chelsea’s Captain John Terry. It must be tough to be him that night. Something like the sky fell down to you and said THAT’S YOUR FAULT. I can’t imagine how down he was that night, but I got a lot of lectures from him that night.

From the letter that he made after the final, I can conclude that he’s a truly great leader and tough guy. How come..?? A truly great leader and tough guy is someone who responsible in all things that he has done no matter if it’s good or bad, and I’ve found it in John Terry. And also, I’m sure that he’s one of kind person for his team, family and friends, because he got amazing supports from those who love him. That’s so important when we down, like a fire that fallen by the rain.

And couple days ago, England got a friendly match with USA. He was successfully scored a goal and every eyes look at how a great Captain of both English and Chelsea has risen up from his sadness. What a great character of John Terry..

I have great days a few days ago. Me and my friend went to Jakarta last week to join "Retret Pengurus KP Se-GKY - Called To Lead" at Sukabumi. When we arrived at Jakarta, we joined another GKY’s at GKY Citra to stay there that night. We were treated so good there, and we would like to say thank you to our friend at GKY Citra for that. The next day after we arrived at Jakarta, we started to go to Sukabumi to join the "Retret" by bus with another GKY’s. When we got there, we are divided to separated rooms. So there is no one from the same GKY who stayed in the same room. Well, I thought it’s a very brilliant. We couldn’t have any new friends if we are not separated like that. And the fact, all of my friends got their own new friends, so do I. That’s great I think, that’s the reason we were there.

After we arrived there, take a rest, take a bath, and having dinner, we started to attend the first session. The first session started with the personal introduction of every person with another. And then after that, each GKY have to introduce each of their member to audience. The first session it taken by Pdt.Gunawan Tanu and after that we went to our own room to take a sleep.

The second day started with "Saat Teduh" and having breakfast. After that, we started to join every session that day with a different Worship Leader. The Worship Leader is taken from the different GKY. The session went so cheerful, because the sessions is taken by Pdt.Joseph Theo. He took the sessions with a very very good method, so the audience not sleeping with what He tried to explain. The second day is the very very meaningful day that made us know a lot. The second day closed by Pdt.David Tjioe who was full of spirit when He took the last session of the second day.

The third day is the games day. It’s a little bit different with the early day, because we started the activity earlier than the first and second day. We played outbound games that day with our own team. It’s very excited to play games with my friends as a team, and everyone is happy. And after that, we had our lunch and then we went home.

It was one of a very very special moment in my life when I could found a lot of friends there. I enjoy this event so much, so do my GKY Palembang’s friends. I also got a great time with my teammate there, hopefully I could see them again in the rest of my life.

Special regards to our "REHABEAM" (Andre, Christadi, Grace, Retha, Themmy, Evans, Ellen, Bernard) GBU all..

Yesterday was a memorizing moment for me. I’m so glad that I’ve been given a chance in the rest of my life to see someone who was very special in my heart. Ow my God, she’s still like she used to be, although I didn’t recognize her at the first time. She’s still so cute with the same hair style when I saw her for the very first time. I started to imagine when I was a stupid little boy who could only saw her when she passed in front of me. I didn’t have any chances to know her personally. This girl is who what I mean in my previous blog (his story) when I wrote :
"Once, he used to like a girl but he didn’t have enough braveness to talk, or maybe to have a talk with her. So he could only saw her when she passed him."

I wish I could have a chance to know her more and more. And when we know each other, I’ll say that I admired her so much. I’ll say that I’m not what I used to be, this is brand new me. But I don’t know now if I’m the one who she expected to be a friend, because she already got a boyfriend hehe.. It’s almost 10 years since I saw her for the last time. I wanna give thanks to God that I’ve been given a chance to see her one more time.

There were also another things that made me felt something different with my whole activities yesterday. I saw someone special in midday, and at night I saw a lot of cute girls when I took a walk to PTC mall yesterday. I don’t know what all these things mean for me. Maybe that’s a sign that God want to give someone who could be my girlfriend. I hope so.. hehehehe…

Well, I’m not sure about that. But one thing I’m sure that Those things made me realize that I should bring my couple in the prayer..

GBU
3y1

June 15th, 2007. That was the date that my last blog posted. It’s almost 7 months I didn’t post any blogs. Ow I miss to write down so much. The same problem with I used to face, no inspiration to write . It’s a little bit hard for me to write in English, but I’m trying hard so I don’t lose my touch. And today, I’m trying to compile my words in order to celebrate my birthday tomorrow.

Today, January 14th, 2008, a day remaining to my 24 years long journey of life. Huff… For the numbers of time I’ve written, “I’m older and older”. I want to be a young forever, but I know that’s impossible. A lot of tears, happiness, unforgettable moment, till embarrassing moment happened in my life. If I could turn back the time, I won’t change anything that happened in my life. I just want to take a look at it, and maybe close my eyes when I was doing something stupid, and smile when I was doing something proud. I don’t want to fix anything in my past, because I’m so happy with what I’m supposed to be right now. Because I know, all that moments have been making me like this. If I fix one of it, maybe I’m not like this right now. I’m so glad if I’ve been placed in this world with a wonderful family, great parents and very very nice brothers. If I could be like this, it’s because of them too.

Thanks for giving me a good education till I could be like this.

Thanks for the efforts to make me find the way of life.

Thanks for supporting me.

I want to give thanks to Jesus Christ for making me like this, thanks for choosing me and making me like this…

Huff, It’s a long2 time ago since I wrote down on you for the last time couple months ago. I miss to write down on you, I really really miss that.

Recently, I got some new experiences in my life that make me got a spirit to walk through this life. Because I think I started to get bored with my daily activities. Monday, I should wake up in the morning, preparing to go to my office, come back home again in midday to have my lunch, then go to my office again to continue my job, and at 4 O’Clock I go home again. Those activities make my life so bored. I got no spirit to face tomorrow because there would be the same day tomorrow until saturday. I try to make some brand new activities to light up my life again. Those activities are teaching and preparing to be WL.

Teaching is my brand new experience. I enjoy teaching so much rather than my other activities. Well, become a teacher or lecturer is what I dreamt of since I was in Primary School, although I didn’t realize that. I used to think that there is so great become a teacher. You don’t have to learn or memorize the subject or lecture to prepare yourself to take any exams. You just have to prepare the questions for the students and just take a look at them when they do it. Hehe.. I don’t think that I used to think now, but it is. Sometimes I smiled to see my students, especially when they did their exam, because when I saw them, I started to imagine when I was there like them too. hehehe… But..!! I got another thing that I should think about. It is to prepare the subject for them.. A little bit difficult to think and find a lot of inspiration to present or teach them about the subject, especially the theory.. Ouch, I should think hard and spent a lot of time for that, but I enjoy it.. Thank’s God, You’re so kind..

Another new experience is to become a Worship Leader in my church. A brand new experience because I’ve never been a Worship Leader in a great event like KKR. This is the first time for me and I should prepare my self from couple weeks ago. I enjoy it too, because I think it’s a rarely oportunity. I’m so glad that God still want me to work for Him with my talent, and I’ll do my best for it. Ow, I’d like to invite all of you to join us in "Kebaktian Kebangunan Rohani", July 7th 2007 at Gereja Kristus Yesus Jemaat Palembang (IPEKA School, behind Selatan Indah Restaurant). The theme is "Expensive Soul/Jiwamu Berharga" with Pdt.Mangapul Sagala as the preacher. You don’t have to take any invitation to join with us, just come. We’ll be very happy to see you there.
I think that’s all about my brand new expreriences…

GBU,
3y1

Wow.. It’s a long2 time ago since I wrote on you months ago. I’ve passed a lot of events that happenned in my life. But, I got no time and any inspiration to write down on you, though there were a lot of events that I should have written on you. I miss to write down on you so much. I’ve posted my last blog on december last year, so I haven’t written on you for a year… hohoho…
The events that I’ve been passed are from the Christmas to my birthday. I’ve passed a very2 great Christmas and new year eve. I’ve been so busy to prepare all things in church to make a successful Christmas and new year eve events. I’m so glad that I’ve been trusted to prepare all those things, which means that God still want me to work for Him.. :). The time goes by and all those activities has ended. In January 15th 2007, I celebrated my birthday. I’m 23 years old that day, huff… I’m older and older.. hehehe… I’m not wonder that some people do a lot of things to make him/her become younger than he or she is suppose to be. I started to realize now that how it means for someone. I wanna be a young forever, but I know that’s impossible. All I wanna do is just give thanks to the Lord, because I’m exist is just because of Him. I wanna give thanks for all those things that He has done in my life for more than 23 years. And now, I’m counting the days to my graduation. Once again I wanna give thank’s to You Lord for all that You have done. I’ve been struggling, and I could not survive if I’m not with You.
But..!! there’s something missing in my heart right now. I’m in searching for that missing piece in my heart, and I don’t know what is it. Maybe something that able to make me happy, sad, dissapointed, and the other feelings. I had felt that once and I wanna feel it once again. I really miss that.. But I know that I’ll feel it once again.

GBU,
3y1