<% '-------------------------------------------------------------------- ' Microsoft ADO ' ' (c) 1996 Microsoft Corporation. All Rights Reserved. ' ' ' ' ADO constants include file for VBScript ' '-------------------------------------------------------------------- '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- CursorOptionEnum Values ---- Const adHoldRecords = &H00000100 Const adMovePrevious = &H00000200 Const adAddNew = &H01000400 Const adDelete = &H01000800 Const adUpdate = &H01008000 Const adBookmark = &H00002000 Const adApproxPosition = &H00004000 Const adUpdateBatch = &H00010000 Const adResync = &H00020000 Const adNotify = &H00040000 '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 '---- ExecuteOptionEnum Values ---- Const adRunAsync = &H00000010 '---- ObjectStateEnum Values ---- Const adStateClosed = &H00000000 Const adStateOpen = &H00000001 Const adStateConnecting = &H00000002 Const adStateExecuting = &H00000004 '---- CursorLocationEnum Values ---- Const adUseServer = 2 Const adUseClient = 3 '---- DataTypeEnum Values ---- Const adEmpty = 0 Const adTinyInt = 16 Const adSmallInt = 2 Const adInteger = 3 Const adBigInt = 20 Const adUnsignedTinyInt = 17 Const adUnsignedSmallInt = 18 Const adUnsignedInt = 19 Const adUnsignedBigInt = 21 Const adSingle = 4 Const adDouble = 5 Const adCurrency = 6 Const adDecimal = 14 Const adNumeric = 131 Const adBoolean = 11 Const adError = 10 Const adUserDefined = 132 Const adVariant = 12 Const adIDispatch = 9 Const adIUnknown = 13 Const adGUID = 72 Const adDate = 7 Const adDBDate = 133 Const adDBTime = 134 Const adDBTimeStamp = 135 Const adBSTR = 8 Const adChar = 129 Const adVarChar = 200 Const adLongVarChar = 201 Const adWChar = 130 Const adVarWChar = 202 Const adLongVarWChar = 203 Const adBinary = 128 Const adVarBinary = 204 Const adLongVarBinary = 205 '---- FieldAttributeEnum Values ---- Const adFldMayDefer = &H00000002 Const adFldUpdatable = &H00000004 Const adFldUnknownUpdatable = &H00000008 Const adFldFixed = &H00000010 Const adFldIsNullable = &H00000020 Const adFldMayBeNull = &H00000040 Const adFldLong = &H00000080 Const adFldRowID = &H00000100 Const adFldRowVersion = &H00000200 Const adFldCacheDeferred = &H00001000 '---- EditModeEnum Values ---- Const adEditNone = &H0000 Const adEditInProgress = &H0001 Const adEditAdd = &H0002 Const adEditDelete = &H0004 '---- RecordStatusEnum Values ---- Const adRecOK = &H0000000 Const adRecNew = &H0000001 Const adRecModified = &H0000002 Const adRecDeleted = &H0000004 Const adRecUnmodified = &H0000008 Const adRecInvalid = &H0000010 Const adRecMultipleChanges = &H0000040 Const adRecPendingChanges = &H0000080 Const adRecCanceled = &H0000100 Const adRecCantRelease = &H0000400 Const adRecConcurrencyViolation = &H0000800 Const adRecIntegrityViolation = &H0001000 Const adRecMaxChangesExceeded = &H0002000 Const adRecObjectOpen = &H0004000 Const adRecOutOfMemory = &H0008000 Const adRecPermissionDenied = &H0010000 Const adRecSchemaViolation = &H0020000 Const adRecDBDeleted = &H0040000 '---- GetRowsOptionEnum Values ---- Const adGetRowsRest = -1 '---- PositionEnum Values ---- Const adPosUnknown = -1 Const adPosBOF = -2 Const adPosEOF = -3 '---- enum Values ---- Const adBookmarkCurrent = 0 Const adBookmarkFirst = 1 Const adBookmarkLast = 2 '---- MarshalOptionsEnum Values ---- Const adMarshalAll = 0 Const adMarshalModifiedOnly = 1 '---- AffectEnum Values ---- Const adAffectCurrent = 1 Const adAffectGroup = 2 Const adAffectAll = 3 '---- FilterGroupEnum Values ---- Const adFilterNone = 0 Const adFilterPendingRecords = 1 Const adFilterAffectedRecords = 2 Const adFilterFetchedRecords = 3 Const adFilterPredicate = 4 '---- SearchDirection Values ---- Const adSearchForward = 1 Const adSearchBackward = -1 '---- ConnectPromptEnum Values ---- Const adPromptAlways = 1 Const adPromptComplete = 2 Const adPromptCompleteRequired = 3 Const adPromptNever = 4 '---- ConnectModeEnum Values ---- Const adModeUnknown = 0 Const adModeRead = 1 Const adModeWrite = 2 Const adModeReadWrite = 3 Const adModeShareDenyRead = 4 Const adModeShareDenyWrite = 8 Const adModeShareExclusive = &Hc Const adModeShareDenyNone = &H10 '---- IsolationLevelEnum Values ---- Const adXactUnspecified = &Hffffffff Const adXactChaos = &H00000010 Const adXactReadUncommitted = &H00000100 Const adXactBrowse = &H00000100 Const adXactCursorStability = &H00001000 Const adXactReadCommitted = &H00001000 Const adXactRepeatableRead = &H00010000 Const adXactSerializable = &H00100000 Const adXactIsolated = &H00100000 '---- XactAttributeEnum Values ---- Const adXactCommitRetaining = &H00020000 Const adXactAbortRetaining = &H00040000 '---- PropertyAttributesEnum Values ---- Const adPropNotSupported = &H0000 Const adPropRequired = &H0001 Const adPropOptional = &H0002 Const adPropRead = &H0200 Const adPropWrite = &H0400 '---- ErrorValueEnum Values ---- Const adErrInvalidArgument = &Hbb9 Const adErrNoCurrentRecord = &Hbcd Const adErrIllegalOperation = &Hc93 Const adErrInTransaction = &Hcae Const adErrFeatureNotAvailable = &Hcb3 Const adErrItemNotFound = &Hcc1 Const adErrObjectInCollection = &Hd27 Const adErrObjectNotSet = &Hd5c Const adErrDataConversion = &Hd5d Const adErrObjectClosed = &He78 Const adErrObjectOpen = &He79 Const adErrProviderNotFound = &He7a Const adErrBoundToCommand = &He7b Const adErrInvalidParamInfo = &He7c Const adErrInvalidConnection = &He7d Const adErrStillExecuting = &He7f Const adErrStillConnecting = &He81 '---- ParameterAttributesEnum Values ---- Const adParamSigned = &H0010 Const adParamNullable = &H0040 Const adParamLong = &H0080 '---- ParameterDirectionEnum Values ---- Const adParamUnknown = &H0000 Const adParamInput = &H0001 Const adParamOutput = &H0002 Const adParamInputOutput = &H0003 Const adParamReturnValue = &H0004 '---- CommandTypeEnum Values ---- Const adCmdUnknown = &H0008 Const adCmdText = &H0001 Const adCmdTable = &H0002 Const adCmdStoredProc = &H0004 '---- SchemaEnum Values ---- Const adSchemaProviderSpecific = -1 Const adSchemaAsserts = 0 Const adSchemaCatalogs = 1 Const adSchemaCharacterSets = 2 Const adSchemaCollations = 3 Const adSchemaColumns = 4 Const adSchemaCheckConstraints = 5 Const adSchemaConstraintColumnUsage = 6 Const adSchemaConstraintTableUsage = 7 Const adSchemaKeyColumnUsage = 8 Const adSchemaReferentialContraints = 9 Const adSchemaTableConstraints = 10 Const adSchemaColumnsDomainUsage = 11 Const adSchemaIndexes = 12 Const adSchemaColumnPrivileges = 13 Const adSchemaTablePrivileges = 14 Const adSchemaUsagePrivileges = 15 Const adSchemaProcedures = 16 Const adSchemaSchemata = 17 Const adSchemaSQLLanguages = 18 Const adSchemaStatistics = 19 Const adSchemaTables = 20 Const adSchemaTranslations = 21 Const adSchemaProviderTypes = 22 Const adSchemaViews = 23 Const adSchemaViewColumnUsage = 24 Const adSchemaViewTableUsage = 25 Const adSchemaProcedureParameters = 26 Const adSchemaForeignKeys = 27 Const adSchemaPrimaryKeys = 28 Const adSchemaProcedureColumns = 29 %> <%Function Month_Name(inputdate) intMonth=Month(inputdate) Select Case intMonth Case "1" strMonth="Jan" Case "2" strMonth="Feb" Case "3" strMonth="Mar" Case "4" strMonth="Apr" Case "5" strMonth="May" Case "6" strMonth="June" Case "7" strMonth="July" Case "8" strMonth="Aug" Case "9" strMonth="Sep" Case "10" strMonth="Oct" Case "11" strMonth="Nov" Case "12" strMonth="Dec" Case "" strMonth=Month(Date()) End Select Month_Name=strMonth End Function function toSQLDate(dateInput) strYear = CStr(Year(dateInput)) strMonth = CStr(Month(dateInput)) strDay = CStr(Day(dateInput)) If Len(strDay) = 1 Then strday = "0" + strDay ElseIf Len(strDay) = 0 Then strday = "00" End If If Len(strMonth) = 1 Then strmonth = "0" & strMonth ElseIf Len(strMonth) = 0 Then strmonth = "00" End If toSQLDate = strYear + "-" + strmonth + "-" + strday end function 'Dim objConn 'Set objConn = Server.CreateObject("ADODB.Connection") 'objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _ ' "Data Source= C:\Inetpub\DigitalShip\Users.mdb" Dim objConn 'Set objConn = CreateObject("MySQL.Connection") 'objConn.Connect "mysql50-34.wc1", "358252_fryesaa1", "SruBQgem1", "358252_fryesaa1", 3306, 3 'Dim objConn 'ConnectionString = "Driver={mySQL ODBC 5.1 Driver};Server=mysql.thedigitalship.com;Port=3306;Option=3;Database=fryesaa1;Uid=fryesaa1;Pwd=hAEG6zaX;" ' ConnectionString = "Driver={mySQL ODBC 5.1 Driver};Server=209.62.36.4;Port=3306;Option=3;Database=lngjourn_DS;Uid=lngjourn_fryesaa;Pwd=SruBQgem;" ConnectionString = "Driver={mySQL ODBC 3.51 Driver};Server=mysql50-34.wc1;Port=3306;Option=3;Database=358252_fryesaa1;Uid=358252_fryesaa1;Pwd=SruBQgem1;" 'ConnectionString = "DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://mysql.thedigitalship.com/fryesaa1};uid=fryesaa1;pwd=hAEG6zaX;" set objConn = Server.CreateObject("ADODB.Connection") objConn.open(ConnectionString) 'Dim objConn 'Set objConn = Server.CreateObject("ADODB.Connection") 'objConn.Open "dsn=pc05;db=digitalship;uid=root" If Session("blnValidUser") = True and Session("PersonID") = "" Then Dim rsPersonIDCheck Set rsPersonIDCheck = Server.CreateObject("ADODB.Recordset") Dim strSQL strSQL = "SELECT PersonID FROM webuser " & _ "WHERE EMailAddress = '" & Session("EMailAddress") & "';" rsPersonIDCheck.Open strSQL, objConn If rsPersonIDCheck.EOF Then Session("blnValidUser") = False Else Session("PersonID") = rsPersonIDCheck("PersonID") End If rsPersonIDCheck.Close Set rsPersonIDCheck = Nothing End If %>
 
 
 
The world's leading magazine and events company for information technology in the deep sea commercial maritime industry
<% If Session("blnValidUser") = True Then %> Update User Details | Logout <% Else %> Login | Register <% End If %>

thedigitalship www

Who reads Digital Ship?

This is a list of some of the people who have specifically requested to receive Digital Ship magazine since June 2007.


"K" Line Ship Management Co., Ltd., Marine Superintendent, Japan

A.&Marine(Thai)co.,ltd, Managing Director, Thailand

A.M.Kyprosun Marine Services Ltd, Managing Director, Cyprus

Acergy MS Ltd, IMS Technical Manager, Great Britain

AET Tankers Pte Ltd, IT Manager, Singapore

Africa Express Line Ltd, Operations Administrator, Great Britain

Alaska Tanker Co. LLC, Marine Personnel, USA

Alcoa Steamship Company, Manager, Bulk Services, USA

AM Nomikos TWMA S.A, IT Manager, Greece

AMO International Corp, Director, Australia

Anangel Maritime Services, Senior Electronic Engineer, Greece

Andros Maritime Agencies, IT Manager, Great Britain

ASIMAR, Mechanical.engineer, Thailand

ASP Ship Management, Business Systems Manager, Australia

Atlantic Container Line, Corp. Procurement Manager, USA

ATLANTIC MARITIME SERVICES, Manager, Cameroon

AYGAZ A.S., Quality Management Representative, Turkey

Belgian Navy, NAMESIS manager, Belgium

BGT Limited, Risk Manager and Operations Coordinator, USA

Bibby International Services, QA & Safety Rep, Great Britain

Bibby International Services, Training Manager, Great Britain

Bibby International Services Group Ltd, Business Development Manager, Great Britain

Bonag Inc., President, USA

Bourbon, QHSE Manager, France

Bourbon Offshore Greenmar, Managing Director, Switzerland

Boyattships Ltd, Director, Great Britain

Briese Schiffahrts GmbH & Co. KG, IT-Manager, Germany

Brostrom, Vessel ICT Manager, Sweden

BW Gas ASA, TQM Manager / DPA, Norway

C M Los (London) Ltd, Director, Great Britain

Canadian Coast Guard, Automation Systems Technologist, Canada

Carlton Maritime, CEO, Great Britain

Carnival, Information Systems Manager, USA

Carnival Cruise Lines, Supervisor, Shipboard Technology, USA

Carnival Cruise Lines, Manager, Shipboard Technology, USA

Carras (Hellas) S.A., IT Manager, Greece

Ceres LNG Services, Electrical Superintendent, Greece

Ceres LNG Services Ltd, ICT Manager, Greece

CHANDRIS (HELLAS) INC., I.T. MANAGER, Greece

Chevron, Regional Advisor - Maritime, Great Britain

Chevron Shipping Company LLC, Senior Engineer, USA

Clipper Group A/S, Project Superintendent, Denmark

CSIRO, Systems Analyst, Australia

CSP, Mananger, South Korea

DFM, Marketing Exec, Cyprus

DG+M Metaxas, Consulting Engineer, Greece

Eletson Corporation, System and Network Administrator, Greece

EMS India, GM (Tech), India

ETPRO SAC, Consultant, Peru

Eurasia, Genaral Manager & Principal ECAL, India

Eurasia Maritime Management (India) Pvt. Ltd., Technical Assistant, India

Euroship Services Ltd, IT Support, Great Britain

Finnish Maritime Administration, ENC Specialist, Finland

Finnlines Plc, Project Manager, Finland

FML, Master Mariner, India

Fortune Technologies SA, Managing Director, Greece

Franman Ltd, General Manager, Greece

Galaxy Shipping Corporation, Manager, Sales Dept., Taiwan

G-Class Maritime Ltd, Director, Great Britain

Glencore UK Ltd, Bus Systems Mgr, Great Britain

Gourdomichalis Maritime, IT manager, Greece

Grieg Shipping Group AS, ICT Manager, Norway

Grieg Shipping Group AS, Chief Operating Officer, Norway

Hansabaltic Oy, CEO, Finland

Hanseatic Shipping Co. Ltd, Communication, PR & HR Manager, Cyprus

HAV Ship Holding AS, Managing Director, Norway

Histria Shipmanagement, IT Manager, Romania

Hoegh, EEO, Croatia

Hornbeck Offshore Transportation, Captain, Puerto Rico

Hyundai Merchant Marine, Manager, South Korea

I.M. Skaugen ASA, Vice President IT, Norway

IAL Container Line (UK) Ltd, General Manager, Vessel Operations, United Arab Emirates

InterMac Marine, Owner, Netherlands

Interorient Navigation (USA), Technical Assistant, USA

IRISL, Manager of Telecom Dept, Iran

Isle of Man Steam Packet Company, Marine Operations Manager, Great Britain

J. lauritzen A/S, Solution Manager, Denmark

Jo Tankers, Senior System Consultant, Norway

Keppel FELS, Senior System Engineer, Singapore

Keystone Shipping Co., administrative assistant, USA

Kuwait Oil Tanker Company S.A.K., Superintendent, Kuwait

Kuwait Oil Tanker Company S.A.K., Captain, Kuwait

Laskaridis shipping, fleet manager, Greece

LV Shipping Ltd, Customs Business Manager, Great Britain

Maersk, Senior Category Manager, Denmark

Maersk, Ship Captain, Great Britain

Maersk, Assistant Line Manager, India

Maersk, Executive, Pakistan

Mar Oil Apoio Maritimo Ltda, Mooring Master, Brazil

Marfin Management S.A.M., Director, Monaco

Marine Transport Lines, First Assistant Engineer MV CP Navigator, USA

Marint NZ, Researcher, New Zealand

Maritime Administration, Office of Workforce Development, USA

Maritime and Port Authority, Asst Director (E&C), Singapore

Marmaras Navigation Ltd, Legal Manager, Greece

Marreina Armadora S.A., safety manager, Greece

Military Sealift Command, U.S. Navy, Captain, USA

Minnow Marine Services L.L.C, Operations/Marketing Manager, United Arab Emirates

MISC Berhad, ICT Manager, Malaysia

Mitsui OSK Lines, engine cadet, India

MOL Tankship Management, Vessel IT support engineer, Great Britain

Mosleh Shipping Services Co, Chairman, Egypt

Motia Compagnia Di Naviagzione SpA, designated person, Italy

MSI Ship Management, assistant manager, Singapore

Naftomar Shipping and Trading, IT Manager, Greece

Naizak, Fleet Consultant, United Arab Emirates

Neste Shipping Oy, Marine Superintendent, Finland

Nobpac Shipping Pte, executive, Singapore

NSCSA, M Cordinator, India

NYK SM, junior engg, India

OHM Surveys, Technical Project Manager, Great Britain

Olympic Shipping and Management SA, I.T. Manager, Greece

OM Ships International, Manager of Information Technology, Great Britain

OSG Ship Management (UK) Ltd., Operations Systems Administrator (International Fleet), Great Britain

P&O Maritime Services, Business Systems Manager, Australia

Pacific Consulting Services, Shipping Manager, Australia

Peter Dohle, chief engineer, India

Petroleum Company of Trinidad and Tobago Limited, General Manager, Marketing & Trading, Trinidad and Tobago

PGS Geophysical AS, IT Field support engineer - Global IT dept., Norway

Phoenix Reederei, IT manager, Germany

Polarmarine, marine superintendent, Turkey

Pontoporos Shipping and Trading Ltd., operations manager, Greece

PT Global Trans, manager, Indonesia

QCYC, Rear Commodore, Canada

Quinmarine pty. ltd., managing director, Australia

Reederei F. Laeisz G.m.b.H., Supt., Germany

Rio Tinto, IT Manager, Australia

RMK Marine Shipyard, Project Engineer, Turkey

RNLI, Principal Electronic Engineer, United Kingdom

Royal Huisman Shipyard, engineer, Netherlands

Royal Norwegian Navy, Naval Officer, Norway

Saigon Newport Company, manager, Venezuela

Samos Steamship CO, IT, Greece

Seabulk c/o TM Marketing, VP Sales, USA

Seacastle Singapore Pte Ltd, VP Technical Services, Singapore

Sealion Shipping Ltd, Master, Great Britain

Seaway Marine Transport, LAN Administrator - Ship Systems, Canada

Servicio de Hidrografia naval, Nautical Advisor, Argentina

Sirius Shipping, Master/Operator, Sweden

Star Cruises, Director Electrical Operations, Malaysia

Star Reefers UK Ltd, Sr VP Marine Ops, Great Britain

Stolt-Nielsen Transportation Group, Navigation Superintendent, Netherlands

Stolt-Nielsen Transportation Group, Assistant Navigation Superintendent, Sweden

Swedish Maritime Administration, Deputy Manager, Sweden

Tanker pacific ship management ltd, marine engineer, Bangladesh

Tanker Pacific Singapore, Manager - IT Solutions, Singapore

Teekay Shipping, Business Analyst, Canada

Teekay Shipping, Manager, Projects Office, Canada

Teekay Shipping (Glasgow) Ltd, Contracts Manger, Great Britain

Teo Shipping Corporation, ICT Manager, Greece

The Great Eastern Shipping Co. Ltd., Assistant General Manager (Operations), India

Thrane & Thrane Norge AS, Director Business Development, Norway

Torvald Klaveness Group, Business Architect, Norway

Transmarine Management ApS, MD, Denmark

Transnautic Ship Management, manager, Estonia

Trico Supply AS, IT Manager, Norway

Tsakos Shipping & Trading SA, Assistant Manager, Quality & Safety Dpt., Greece

TSM Pte Ltd, PMS Technical Superintendent, Singapore

Unicorn Shipping, Chief Financial Officer, Turkey

Unique Shipping (HK) LTD, Senior Ship Management Manager, Hong Kong

United States Coast Guard Auxiliary, Marine Safety Officer, USA

US Coast Guard, Satcom Program Manager, USA

Vanguard shipmanagement (S) Pte Ltd, superintendent, Singapore

Vardar Shipping, Sales Manager, Turkey

Vasco Global Maritime, ceo, United Arab Emirates

Vela International Marine, Contracts Advisor, United Arab Emirates

Viking Line Abp, El.tech.Superint., Finland

Vip Chartering Services, Manager, Romania

VShips UK Ltd,, Marine Superintendent, Great Britain

West Caribbean Sea Cargo S.A., managing director, Aruba

West Shore Gorup (USA), CEO, USA

Whale Shipping & Enterprise Inc., Managing Dir., Taiwan

WIlh. WIlhelmsen, VP Strategy & IT, Norway