<% '-------------------------------------------------------------------- ' 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

About Us

Digital Ship is the commercial maritime world’s authority on satellite communications, software, navigation technology and computer based training.

Established in August 2000, Digital Ship publishes a monthly full colour print and electronic magazine, organises large conferences / exhibitions each year in some of the world's most important shipping centres, which have included Hong Kong, Singapore, Hamburg, Norway, Dubai, the USA, Cyprus and Athens, and runs a series of one day sector-specific events. We also provide an online newsletter and networking service to help executives in the maritime industry stay ahead of the very latest developments in shipping IT.

Digital Ship is based in London – our office address is:

Digital Ship Ltd
2nd Floor, 8 Baltic Street East
London, EC1Y 0UP
UK

For General enquiries please contact us on:

Tel: +44 207 253 2700, Fax: +44 251 9179

Please note: our phone number and address changed on July 22 2010.

FOR SPECIFIC ENQUIRIES, PLEASE CONTACT THE RELEVANT DEPARTMENT BELOW

For Editorial enquiries please contact:

Rob O'Dwyer, Editor
Tel: +44 207 017 3410, E-mail: odwyer@thedigitalship.com

Julie Ann Chan, Deputy Editor
Tel: +44 207 017 3414, E-mail: julie@thedigitalship.com

Andy Norris, Consultant Writer

For Advertising and Exhibition Sales enquiries please contact:

Ria Kontogeorgou, Sales Manager
Tel: +44 207 017 3401, E-mail: ria@thedigitalship.com

For Digital Ship Events enquiries please contact:

Diana Leahy, Events Manager
Tel: +44 207 253 2700, E-mail: leahy@thedigitalship.com

For Conference Programme enquiries please contact:

Cathy Hodge, Conference Producer
Tel: +44 7956 965 857, E-mail: cathy@thedigitalship.com

For Subscriptions enquiries please contact:

Stephan Venter, Subscriptions Manager
Tel: +44 207 0173407, E-mail: venter@thedigitalship.com

For Conference Registration enquiries please contact:

Narges Jodeyri, Delegate Sales Manager
Tel: +44 207 017 3412, E-mail: narges@thedigitalship.com

For Magazine Production enquiries please contact:

Vivian Chee, Production Manager
E-mail: chee@btconnect.com


Digital Ship also has several sister companies with shared personnel or shared shareholders

LNG Journal – a magazine covering developments in the LNG sector. www.lngjournal.com

Tanker Operator - news, features and reports on tanker operations. www.tankeroperator.com

Digital Energy Journal - a magazine about information and communications technology in the oil and gas industries. www.digitalenergyjournal.com

Finding Petroleum - Exploration and technology to find petroleum. Forums and conferences in London www.findingpetroleum.com

Carbon Capture Journal - Developments in carbon capture and storage. www.carboncapturejournal.com

Port Finance International - a news and events company for the port finance and development sector. www.portfinanceinternational.com

StocExpo - a series of exhibitions and a print magazine about storage terminals www.stocexpo.com

Drewry Shipping Consultants - www.drewry.co.uk

The Hydrogen Journal - www.h2journal.com


KEY PERSONNEL

Rob O’Dwyer, Editor of Digital Ship, has been a maritime IT journalist since 2005. He has a masters degree in business and law from University College Dublin and was previously a commercial writing consultant in Seoul, South Korea. Rob was also previously Editor of Port Finance International. odwyer@thedigitalship.com

Karl Jeffery, Conference Producer for Digital Ship, is the founding editor of the magazine and has been with the company since 2000. He was previously Editor of Compuship magazine and has been a specialist in maritime information technology for almost a decade. He is also currently Editor of Digital Energy Journal and publisher of Tanker Operator. jeffery@thedigitalship.com

Stuart Fryer, Publisher / Managing Director, is also publisher of LNG Journal, and Container Management. Stuart was also previously publisher of Cargo Systems, Hazardous Cargo Bulletin and Compuship.

Ria Kontogeorgeou, Advertising & Exhibition Sales Manager, is from Athens, Greece, and was previously advertising manager for Greece and Cyprus with Tanker Operator magazine. ria@thedigitalship.com

Vivian Chee, Production Manager, has been responsible for the design and graphic layout of Digital Ship for over 10 years. chee@btconnect.com



CORRESPONDENT WRITERS

Dr Andy Norris is chairman of the IEC (International Electrotechnical Committee) Technical Committee 80, Maritime navigation and radio communication equipment and systems. He is also Special Professor of Navigation Technology, Nottingham University and was previously managing director of ChartCo.


Sectors covered in Digital Ship include:

SHIP SHORE COMMUNICATIONS: New satellite communications services, Inmarsat Global Xpress, FleetBroadband and Fleet, VSAT (Ku-band, C-band), Iridium, Globalstar, Thuraya, maritime GSM services, DVB, seafarer communications and crew welfare, data services, Inmarsat I4 services, equipment, airtime services, software, e-mail systems and services, safety communications, ship security alert systems.

SOFTWARE / DATA SERVICES: Shipping company operations software, shipmanagement software, data acquisition tools, electronic purchasing tools, maintenance software, manning / personnel software, accounting software, networks / data infrastructure, office computer hardware.

SHIPBOARD ELECTRONICS / SAFETY / NAVIGATION SYSTEMS: Chart display systems, ECDIS, charts and ENCs, chart distribution systems, integrated bridges, voyage data recorders, simplified voyage data recorders, automatic identification systems, AIS over satellite, wireless data communication networks, shipboard PCs, safety communication networks, simulation and training systems.

CONTROL SYSTEMS / POWER: Shipboard power generation, shipboard automation systems, fuel cells, power systems, power monitoring systems, gas detection systems

SECURITY TECHNOLOGY: Security training software, identity cards, closed circuit TV cameras, alarms, locks electric fences, smart containers, GMDSS.