%'revised on 28-02-2010 and change link for view details set s_conn=server.createobject("adodb.connection") s_Conn.provider = s_provider s_Conn.ConnectionString = s_dbasepath s_Conn.Open set l_conn=server.createobject("adodb.connection") l_Conn.provider = provider l_Conn.ConnectionString = dbasepath l_Conn.Open speach_sql=" SELECT top 3 speach.s_date, speach.title, speach.spech_no FROM speach order by s_date desc" set speach_rs=s_conn.execute(speach_sql) 'choose max 3 record in load table load_sql="SELECT TOP 3 t_l_day.load, t_l_day.l_day, t_l_day.time_ty,year_dt, month_dt, day_dt " load_sql=load_sql+" FROM t_l_day ORDER BY t_l_day.year_dt DESC , t_l_day.month_dt DESC , t_l_day.day_dt DESC,time_ty" 'response.write(load_sql) set load_rs=l_conn.execute(load_sql) 'choose max 1 record in expected load table exp_load_sql="SELECT TOP 1 expec_l.load, expec_l.temp, expec_l.l_day , expec_l.year_dt, expec_l.month_dt, expec_l.day_dt" exp_load_sql=exp_load_sql+" FROM expec_l ORDER BY expec_l.year_dt DESC , expec_l.month_dt DESC , expec_l.day_dt DESC;" set exp_load_rs=l_conn.execute(exp_load_sql) %>