<% Set cnnCTSI = Server.CreateObject("ADODB.Connection") cnnCTSI.Open "provider=sqloledb; data source=ctsiwebsrv; initial catalog=marianaweb; user id=sa; password=061701" Set rsSchedule = Server.CreateObject("ADODB.Recordset") rsSchedule.ActiveConnection = cnnCTSI rsSchedule.Source = "SELECT * FROM mell_schedule order by sche_code" rsSchedule.CursorType = 1 rsSchedule.CursorLocation = 2 rsSchedule.LockType = 3 rsSchedule.Open %> <% do until rsSchedule.eof %> <% rsSchedule.movenext loop %>

Vessel Name	Voyage Number	Kaoshiung	Manila	Hongkong	Keelung	Saipan	Guam
<%=(rsSchedule.Fields.Item("ship_name").Value)%>	<%=(rsSchedule.Fields.Item("voyage").Value)%>	<%=(rsSchedule.Fields.Item("cy").Value)%>	<%=(rsSchedule.Fields.Item("eta3").Value)%>	<%=(rsSchedule.Fields.Item("etd").Value)%>	<%=(rsSchedule.Fields.Item("keelungd8").Value)%>	<%=(rsSchedule.Fields.Item("eta").Value)%>	<%=(rsSchedule.Fields.Item("eta2").Value)%>
KAPITAN GRISHIN	VM28					Jan 18-19 2005	Jan 19-20 2005
GRANDEUR	VM128					Jan 28-29 2005	Jan 29-30 2005
KAPITAN GRISHIN	VM29			Jan 30-31 2005	Feb 02-02 2005	Feb 07-08 2005	Feb 08-09 2005
UNIVERSAL ISLAND	V16	Feb 02-02 2005		Feb 04-04 2005	Feb 06-06 2005	Feb 11-12 2005	Feb 12-13 2005
GRANDEUR	VM129		Feb 06-06 2005	Feb 08-11 2005		Feb 18-19 2005	Feb 19-20 2005
KAPITAN GRISHIN	VM30			Feb 18-18 2005	Feb 20-20 2005	Feb 25-26 2005	Feb 26-27 2005
UNIVERSAL ISLAND	V17			Feb 25-25 2005	Feb 27-27 2005	Mar 04-05 2005	Mar 05-06 2005
GRANDEUR	VM130	Mar 02-02 2005		Mar 04-04 2005	Mar 06-06 2005	Mar 11-12 2005	Mar 12-13 2005
KAPITAN GRISHIN	VM131	Mar 09-09 2005		Mar 11-11 2005	Mar 13-13 2005	Mar 18-19 2005	Mar 19-20 2005
KAPITAN GRISHIN	VM31	SKIP		Mar 14-15 2005	Mar 17-17 2005	Mar 22-23 2005	Mar23-24 2005
UNIVERSAL ISLAND	V18	Mar 19-19 2005		Mar 20-20 2005	Mar 22-22 2005	Mar 27-28 2005	Mar 28-29 2005

back to homepage >>