VBA is a very good tool to manage data. I always write some mini VBA programs to manipulate database data and create SQLs. Apart from programming, it also gives me some valuable memories with Tinyan
Let’s back to the topic. In VBA, we use Mid() to substring. Continue reading VBA – Substring Function
I found a good article which the author shows you how to select random records from table among different kind of databases.
Here are the example for SQLite, MySQL and PostgreSQL.
Continue reading SQL – Select Random Records From Table
每個星期天，《城市論壇 》主持謝志峰都站在維園 最前線，當上公正專業的角色，讓台下的一群阿哥、阿伯輪流發言，表達意見。
離開維園，回復了爸爸的身分，他不期然變身維園阿叔，向香港的教育制度發炮。
「香港的教育制度，不論學生是什麼材料，不論他是海鮮，還是其他，都要『啤』一粒燒賣出來。」
「香港的教育制度，要孩子天天吃鮑參翅肚，永遠沒有空閒，逼得太緊，跟富士康 差不多。」感同身受，只因女兒曾是這個制度下的一粒燒賣。爸爸唯一可做的，就是出盡全力，咬緊牙關，付錢讓女兒接受一套西方教育，避免她成為高溫蒸籠內的一粒沒有個性的燒賣。
Continue reading 謝志峰轟港教育 不想女兒變燒賣
每當有關香港政制改革的新聞傳入大陸，就總會有人在網上留言，說「香港人怎麼以前不向英國爭取民主，現在回歸了才來爭民主呢」。每次看到這種言論，我都不知該說什麼才好。
首先，它的前提是錯的。香港人的民主運動成形於上世紀80年代；早在英殖民末期，今天香港檯面上的「民主派」就已經是當時十分活躍的政治人物了。所以說出這種話的大陸網民恐怕不太瞭解香港。其次，這句話把重點放在了向誰爭取民主這個問題上面，而非爭取民主本身；似乎民主運動本身沒有內在的道德價值，是非對錯全看你是在向什麼人爭取民主。向英國人要民主就對，跟自己人計較就是居心不良，這難道不是一種價值的移位和錯置嗎？
Continue reading 梁文道 – 香港政改再思考
Finally i got one iPhone Application approved by app store. Actually this is my second iPhone app. The first one is rejected by app store since i didn’t handle the missing camera issue in iPod Touch. Hopefully, i will resubmit the first one soon.
Continue reading Story Smart – My First Approved iPhone App
特區政府推行「通識教育」，慘遭前宗主英國的考試局公然歧視，只承認香港高考理化史地的學科成績，獨「通識」這一科考試，英國不予承認。洋人不承認，壞了，「通識」還讀來做什麼？本人兩年前已經鐵批：「香港的通識教育」，一定死路一條。
我宣判了，英國考試局執行。香港的學校和家長，就該有數了，趕快取消通識這一科，時間省下來，寧願讓小孩玩電腦遊戲，至少電腦遊戲，還可以訓練小腦條件反射，通識，卻會淪為「通蠢」。
因為據說沒有「課程範圍」，不知教什麼，怎樣出題，怎樣評分改卷。為了方便「考試」，漸漸許多懶人自作主張，把「通識」定為「時事討論」，從國際新聞、世界盃，到余曾鬥嘴、功能組別，都可列為「通識教育」。
Continue reading 陶傑 – 通識敗局
Previously, i was working with an web application which allows me to upload a certificate into a keystore. Unfortunately, it only accept certificate in Base64/PEM format but not binary. So i have to convert the certificate into Base64/PEM and this could be done by Portecle.
Portecle is a very useful Java program with User Interface which make keystore and certificate management a piece of cake. The following screenshots show you how to get the Base64/PEM encoding from a binary certificate. Continue reading Portecle – Keystore and Certification Manager
In UILabel, there is an adjustsFontSizeToFitWidth property which will automatically adjust the text font size to fit the UILabel width.
UILabel *aLabel = [[UILabel alloc] initWithFrame:CGRectMake(0.0, 0.0, 320.0, 20.0)]; aLabel.adjustsFontSizetoWidth = YES; // This is a must aLabel.minimumFontSize = 8.0f; aLabel.numberOfLines = 1; // This is a must too =.=
But this only work for numberOfLines = 1… Continue reading iPhone – Wrap Text in UILabel
Normally, the maven-jetty-plugin should be configured in the pom of your Maven webapp project/module. But the project i am working is a legacy Java project with many modules and the webapp module depends on others. so i cannot simply start it due to the build sequence.
What i am going to do is to add an new Maven module for integration test of the Maven webapp module and it would be build in the last module such that all other modules are ready.
Continue reading Maven – Using maven-jetty-plugin to Start a webapp of another Maven Module
The punishment which the wise suffer who refuse to take part in the government, is to live under the government of worse men.
Plato/Plátōn
Eureka! 