2009年11月8日 星期日

gospel forum preparation

1. check football schedule, make sure traffic not a problem.
2. any potential friends coming
3. saint training
4. estimating Total#

2009年11月4日 星期三

miracle - ziqi show up in prayer meeting

this morning prayed from 3:30-6:00.

ziqi showed up in prayer meeting out of no where. she stopped meeting for 2+ years.

miracle - helped zhu lu

zhu lu stopped meeting for a while.

miraclously met him at chinese store and his car was dead. so helped him.

2009年8月19日 星期三

Report on Taiwan Typhoon Damage

As you may be aware of the recent typhoon that devastated Taiwan causing great loss of lives and properties. The following is a brief oral report from Brother Paul Wu in Taiwan:
One saint died and about 40 families suffered property loses. There are about total 30 churches are in the typhoon covered area. Overall southern Taiwan suffers heavy loss on building, road and bridge infrastructures. Death toll may reaches 500 and over one thousand civilians are still being trapped.
Church in Taipei takes the lead to give over 400,000 US dollars to 6 major southern Taiwan county governments for immediate disaster relief. The total donation may reach 1 million US dollars.
In addition to over 300 saints from local affected area churches, over 400 saints from other churches are now helping all affected residents in spiritual and mental care which proofs to be most effective than Red Cross or any other relief entities can do. The affected residences now need the most is the gospel. They receives much helps and comforts in praying and singing with our saints.
Unlike the previous 911 earthquake as a result of a sudden impact, the recovery can take place right away. This disaster recovery is hindered by still many people are buried under heavy mud and blockage of reaching to the immediate affected area by road access.

2009年6月23日 星期二

vb.net oralce

Imports Oracle.DataAccess.Client
Public Class Form1 Private oradb As String = "Data Source=(DESCRIPTION=" _ + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aixxxxx)(PORT=1521)))" _ + "(CONNECT_DATA=(SERVER=DEDICATED)(SID=xxxxx)));" _ + "User Id=xxxx;Password=xxxx;"
Private conn As OracleConnection = New OracleConnection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try conn.ConnectionString = oradb conn.Open() Dim cmd As OracleCommand Dim dr As OracleDataReader Dim sql As String sql = "select * from DIM_XXX where FISC_DATE = to_date('062209','MMDDYY')" cmd = New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text
dr = cmd.ExecuteReader ' Visual Basic dr.Read() Dim iDayID As Integer = dr.Item("DAY_ID")
sql = "select STORE_ID from DIM_yyyy where STORE_NBR = 123" ' VB.NET cmd = New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text dr = cmd.ExecuteReader ' Visual Basic dr.Read() Dim iStoreID As Integer = dr.Item("STORE_ID")
sql = "INSERT INTO FACT_zzzzz (DAY_ID, STORE_ID, SEQ_ID, POS_NUM, POS_REBOOT_DATE_TIME, POS_REBOOT_RECORDED_TMS)VALUES (20090622,00219,fact_pos_metric_daily_seq.nextval,01,to_date('090622 21:02:45','YYMMDD hh24:mi:ss'),to_date('090622 21:02:55','YYMMDD hh24:mi:ss'))" cmd = New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text Dim iR As Integer iR = cmd.ExecuteNonQuery ' Visual Basic
'sql = "select * from FACT_zzzzz where STORE_ID = 456" ' VB.NET sql = "SELECT z, x, TO_CHAR(REBOOT_DATE_TIME, 'dd-mon-yyyy hh24:mi:ss'),TO_CHAR(REBOOT_RECORDED_TMS, 'dd-mon-yyyy hh24:mi:ss') from FACT_POS_METRIC_DAILY" ' VB.NET cmd = New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text dr = cmd.ExecuteReader ' Visual Basic dr.Read() Dim I As Integer = dr.Item(0) Dim s1 As String = dr.Item(1) Dim s2 As String = dr.Item(2) Dim s3 As String = dr.Item(3) Dim dtDateTime As DateTime = dr.Item(4) Dim sD As String = dtDateTime.ToString("yyyy/MM/dd hh:mm:ss") Dim dtDateTime1 As DateTime = dr.Item(5) dr.Dispose() cmd.Dispose() conn.Dispose()
Catch ex As Exception MessageBox.Show(ex.Message.ToString())
End Try End SubEnd Class