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

SUBSCRIBE TO DIGITAL SHIP MAGAZINE

GBP £150 / Euro €225 a year

Subscribe to Digital Ship magazine print magazine

Digital Ship magazine provides the latest information about maritime satellite communications technology, software systems, navigation technology, computer networks, data management and TMSA. It is published ten times a year.

To subscribe, please contact our subscriptions manager Stephan Venter in London on venter@thedigitalship.com, Tel (+44 207) 017 3407, who will arrange an invoice for payment.

Companies which have taken out paid subscriptions to Digital Ship include:

Leif Høegh & Co. ASA, Graig Shipping Plc, Maersk Tankers, Wallem Shipping Ltd., Maersk Espana SA, Clipper Group-Clipper Denmark AS, Avin International SA, Hempel's Marine Paints A/S, Heidenreich Marine, OBC Shipping Limited, Wallem Limited, Shell International Ltd, Overseas Private Investment Corp, Mediterranean Shipping Co., Barber Marine Consultants AS, Cal Maritime, Chellaram Shipping (Hong Kong) Ltd, Odfjell ASA, AP Moller Maersk Sealand, Aegis Marine Inc., Naval Material Command Denmark, Inchcape Shipping Services, Ashland Specialty Chemical, World-Wide Shipping, Delmarva Marine, Lugenbuhl, Wheaton, Peck, Rankin & Hubbard, Aries Shipbroking (Asia) P/L, Naval Material Command Denmark, HanseNautic GmbH, Fidelio Cruise Software GmbH, Maritime Safety Queensland, Thome Ship Management, Elcome International LLC, Chevron Texaco Shipping Company, Durrants Ltd, Eletson Corp, TSM Shipping (Phils) Inc, U.S Merchant Marine Academy, Royal Caribbean Cruises Ltd, Safety & Environment, Amver United Coast Guard, US Merchant Marine Academy, Marine Exchange of Puget Sound, Boeing, Det Norske Veritas AS, Fuel & Marine Marketing, Gemeenteluk Havenbedryf Antwerpen, Seacrest Shipping Co. Ltd, SUNY Maritime College, Royal Arctic Line A/S, Washington State Ferries, Marine Exchange of Alaska, Bams Maritime SRL, Dimars Co Ltd., Sigma Marine & Protective Coatings Netherlands BV, AGIP PETROLI CONMAR, Transpetro - Petrobras Transporte S/A, Teo Shipping Corporation, Franman Ltd, Meridian Surveys Sdn Bhd, Westland/Utrecht Hypotheekbank N.V, World Maritime University, Suomalainen Kirjakauppa, Thenmaris (Ship Management) Inc., UK Maritime and Coastal Agency, Ports of Ukraine Publications, Hyundai Heavy Industries, Wallem Services Ltd, World-Wide Shipping, Norbulk Shipping UK, Bolero Association, Navarik Corp, NYK Shipmanagement Pte Ltd, Johnson Bros. Corp., Golar Management Limited

Should you be thinking about moving to electronic chart systems What are the current options in broadband maritime communications? How much do you need to spend on IT and satellite communications?

What is the best systems for running your corporate intranet? How can technology do the most to improve ship safety - how can you use technology to demonstrate that your shipping company is following best practise, as defined by oil companies and shipowners?

The answers to these questions are changing all the time and involve large amounts of personal preference - but Digital Ship will provide you with the information you need to make the right decision.

Our print magazine is supported by our annual series of events in Norway, Greece, Cyprus and Singapore, expanding in 2011 to include new events in South Korea and Turkey. Digital Ship conferences give shipping company IT, safety, purchasing and electrotechnical managers the opportunity to gather and talk about their own experiences, views and desires, with the major issues raised also enhancing the coverage in Digital Ship.

We also attend the big maritime trade shows, Posidonia, Norshipping and SMM, to gather detailed information about the latest technology and innovation and you will find this written in detail in Digital Ship.

CONTENTS IN MORE DEPTH

SECURITY - Practical application of the ISPS code, training and monitoring the ISPS code, seafarer ID cards, reducing shipboard piracy, container shipping security, port security, Smart and Secure Tradelanes, container security initatives

SAFETY / ELECTRONICS - electronic charts, ECDIS, bridge systems and equipment, automatic identification systems, shipboard alert systems, ALSO changing role of class societies, regulation / policy

SATCOMS - Inmarsat Fleet, FleetBroadband and Global Xpress, Ku-band and C-band VSAT, shipboard information services, ship tracking, ship-shore communications by e-mail, data and voice, Iridium, sending weather, chart updates, training materials to ship, sending ship operations information back to shore

SOFTWARE - shipboard e-mail software, maintenance management, computer based training, simulators, web services, shipping company software, communications with brokers, charterers and agents, shipping agent systems

We produce:

- 10 issues a year of the DIGITAL SHIP print magazine, with in-depth analysis

- A lively international events programme

- A weekly e-mail newsletter

- Consultancy reports