网站建设| 数据库类| 图形图象| 程序设计| 现代办公| 操作系统| 考试认证| 网络技术| 软件工程| 电脑相关| 文学作品
网站开发| 网页制作| 操作系统| 图象图形| 考试认证| 数据库类| 程序设计| 硬件技术| 现代办公| 网络技术| 笑话频道
 
您的位置: 电脑书库首页-> 电脑文摘-> 网站开发-> 其它-> ASP经典包含文件(ADO for VBScript)

ASP经典包含文件(ADO for VBScript)
作者:佚名 来源:InterNet 加入时间:2005-4-4
相关文章
  • Invalid procedure call or argument: Chr 如何解决呢
  • ASP脚本循环语句
  • 精彩:用Asp实现QQ在线查询
  • 用ASP动态生成JavaScript的表单验证代码
  • 硬盘文件搜索代码(ASP类)
  • 文件的读出 编辑 管理
  • 怎样判断一个盘上是否有文件
  • 如何利用ASP把图片上传到数据库
  • 使用ASP建设私人搜索引擎
  • 相关书籍:
  • asp基础教材
  • ASP.NET编程常用的函数集
  • ASP函数速查手册
  • W3CSHOOL标准ASP入门教程
  • ASP中100个为什么
  • ASP经典入门之ADO基础教程
  • ASP基础简明教程
  • w3school asp电子书
  • ASP中文速查手册
  • ASP与相关数据库技术高级指南
  • <%
    '--------------------------------------------------------------------
    ' Microsoft ADO
    '
    ' Copyright (c) 1996-1998 Microsoft Corporation.
    '
    '
    '
    ' 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
    Const adFind = &H00080000
    Const adSeek = &H00400000
    Const adIndex = &H00800000

    '---- LockTypeEnum Values ----
    Const adLockReadOnly = 1
    Const adLockPessimistic = 2
    Const adLockOptimistic = 3
    Const adLockBatchOptimistic = 4

    '---- ExecuteOptionEnum Values ----
    Const adAsyncExecute = &H00000010
    Const adAsyncFetch = &H00000020
    Const adAsyncFetchNonBlocking = &H00000040
    Const adExecuteNoRecords = &H00000080

    '---- ConnectOptionEnum Values ----
    Const adAsyncConnect = &H00000010

    '---- ObjectStateEnum Values ----
    Const adStateClosed = &H00000000
    Const adStateOpen = &H00000001
    Const adStateConnecting = &H00000002
    Const adStateExecuting = &H00000004
    Const adStateFetching = &H00000008

    '---- 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
    Const adChapter = 136
    Const adFileTime = 64
    Const adPropVariant = 138
    Const adVarNumeric = 139
    Const adArray = &H2000

    '---- 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
    Const adFldIsChapter = &H00002000
    Const adFldNegativeScale = &H00004000
    Const adFldKeyColumn = &H00008000
    Const adFldIsRowURL = &H00010000
    Const adFldIsDefaultStream = &H00020000
    Const adFldIsCollection = &H00040000

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

    '---- BookmarkEnum 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 adAffectAllChapters = 4

    '---- ResyncEnum Values ----
    Const adResyncUnderlyingValues = 1
    Const adResyncAllValues = 2

    '---- CompareEnum Values ----
    Const adCompareLessThan = 0
    Const adCompareEqual = 1
    Const adCompareGreaterThan = 2
    Const adCompareNotEqual = 3
    Const adCompareNotComparable = 4

    '---- FilterGroupEnum Values ----
    Const adFilterNone = 0
    Const adFilterPendingRecords = 1
    Const adFilterAffectedRecords = 2
    Const adFilterFetchedRecords = 3
    Const adFilterConflictingRecords = 5

    '---- SearchDirectionEnum Values ----
    Const adSearchForward = 1
    Const adSearchBackward = -1

    '---- PersistFormatEnum Values ----
    Const adPersistADTG = 0
    Const adPersistXML = 1

    '---- StringFormatEnum Values ----
    Const adClipString = 2

    '---- 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
    Const adModeRecursive = &H400000

    '---- RecordCreateOptionsEnum Values ----
    Const adCreateCollection = &H00002000
    Const adCreateStructDoc = &H80000000
    Const adCreateNonCollection = &H00000000
    Const adOpenIfExists = &H02000000
    Const adCreateOverwrite = &H04000000
    Const adFailIfNotExists = -1

    '---- RecordOpenOptionsEnum Values ----
    Const adOpenRecordUnspecified = -1
    Const adOpenSource = &H00800000
    Const adOpenAsync = &H00001000
    Const adDelayFetchStream = &H00004000
    Const adDelayFetchFields = &H00008000

    '---- 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 adErrProviderFailed = &Hbb8
    Const adErrInvalidArgument = &Hbb9
    Const adErrOpeningFile = &Hbba
    Const adErrReadFile = &Hbbb
    Const adErrWriteFile = &Hbbc
    Const adErrNoCurrentRecord = &Hbcd
    Const adErrIllegalOperation = &Hc93
    Const adErrCantChangeProvider = &Hc94
    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 adErrNotReentrant = &He7e
    Const adErrStillExecuting = &He7f
    Const adErrOperationCancelled = &He80
    Const adErrStillConnecting = &He81
    Const adErrInvalidTransaction = &He82
    Const adErrUnsafeOperation = &He84
    Const adwrnSecurityDialog = &He85
    Const adwrnSecurityDialogHeader = &He86
    Const adErrIntegrityViolation = &He87
    Const adErrPermissionDenied = &He88
    Const adErrDataOverflow = &He89
    Const adErrSchemaViolation = &He8a
    Const adErrSignMismatch = &He8b
    Const adErrCantConvertvalue = &He8c
    Const adErrCantCreate = &He8d
    Const adErrColumnNotOnThisRow = &He8e
    Const adErrURLIntegrViolSetColumns = &He8f
    Const adErrURLDoesNotExist = &He8f
    Const adErrTreePermissionDenied = &He90
    Const adErrInvalidURL = &He91
    Const adErrResourceLocked = &He92
    Const adErrResourceExists = &He93
    Const adErrCannotComplete = &He94
    Const adErrVolumeNotFound = &He95
    Const adErrOutOfSpace = &He96
    Const adErrResourceOutOfScope = &He97
    Const adErrUnavailable = &He98
    Const adErrURLNamedRowDoesNotExist = &He99
    Const adErrDelResOutOfScope = &He9a
    Const adErrPropInvalidColumn = &He9b
    Const adErrPropInvalidOption = &He9c
    Const adErrPropInvalidValue = &He9d
    Const adErrPropConflicting = &He9e
    Const adErrPropNotAllSettable = &He9f
    Const adErrPropNotSet = &Hea0
    Const adErrPropNotSettable = &Hea1
    Const adErrPropNotSupported = &Hea2
    Const adErrCatalogNotSet = &Hea3
    Const adErrCantChangeConnection = &Hea4
    Const adErrFieldsUpdateFailed = &Hea5
    Const adErrDenyNotSupported = &Hea6
    Const adErrDenyTypeNotSupported = &Hea7

    '---- 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
    Const adCmdFile = &H0100
    Const adCmdTableDirect = &H0200

    '---- EventStatusEnum Values ----
    Const adStatusOK = &H0000001
    Const adStatusErrorsOccurred = &H0000002
    Const adStatusCantDeny = &H0000003
    Const adStatusCancel = &H0000004
    Const adStatusUnwantedEvent = &H0000005

    '---- EventReasonEnum Values ----
    Const adRsnAddNew = 1
    Const adRsnDelete = 2
    Const adRsnUpdate = 3
    Const adRsnUndoUpdate = 4
    Const adRsnUndoAddNew = 5
    Const adRsnUndoDelete = 6
    Const adRsnRequery = 7
    Const adRsnResynch = 8
    Const adRsnClose = 9
    Const adRsnMove = 10
    Const adRsnFirstChange = 11
    Const adRsnMoveFirst = 12
    Const adRsnMoveNext = 13
    Const adRsnMovePrevious = 14
    Const adRsnMoveLast = 15

    '---- 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 adSchemaReferentialConstraints = 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
    Const adSchemaDBInfoKeywords = 30
    Const adSchemaDBInfoLiterals = 31
    Const adSchemaCubes = 32
    Const adSchemaDimensions = 33
    Const adSchemaHierarchies = 34
    Const adSchemaLevels = 35
    Const adSchemaMeasures = 36
    Const adSchemaProperties = 37
    Const adSchemaMembers = 38
    Const adSchemaTrustees = 39

    '---- FieldStatusEnum Values ----
    Const adFieldOK = 0
    Const adFieldCantConvertValue = 2
    Const adFieldIsNull = 3
    Const adFieldTruncated = 4
    Const adFieldSignMismatch = 5
    Const adFieldDataOverflow = 6
    Const adFieldCantCreate = 7
    Const adFieldUnavailable = 8
    Const adFieldPermissionDenied = 9
    Const adFieldIntegrityViolation = 10
    Const adFieldSchemaViolation = 11
    Const adFieldBadStatus = 12
    Const adFieldDefault = 13
    Const adFieldIgnore = 15
    Const adFieldDoesNotExist = 16
    Const adFieldInvalidURL = 17
    Const adFieldResourceLocked = 18
    Const adFieldResourceExists = 19
    Const adFieldCannotComplete = 20
    Const adFieldVolumeNotFound = 21
    Const adFieldOutOfSpace = 22
    Const adFieldCannotDeleteSource = 23
    Const adFieldReadOnly = 24
    Const adFieldResourceOutOfScope = 25
    Const adFieldAlreadyExists = 26
    Const adFieldPendingInsert = &H10000
    Const adFieldPendingDelete = &H20000
    Const adFieldPendingChange = &H40000
    Const adFieldPendingUnknown = &H80000
    Const adFieldPendingUnknownDelete = &H100000

    '---- SeekEnum Values ----
    Const adSeekFirstEQ = &H1
    Const adSeekLastEQ = &H2
    Const adSeekAfterEQ = &H4
    Const adSeekAfter = &H8
    Const adSeekBeforeEQ = &H10
    Const adSeekBefore = &H20

    '---- ADCPROP_UPDATECRITERIA_ENUM Values ----
    Const adCriteriaKey = 0
    Const adCriteriaAllCols = 1
    Const adCriteriaUpdCols = 2
    Const adCriteriaTimeStamp = 3

    '---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----
    Const adPriorityLowest = 1
    Const adPriorityBelowNormal = 2
    Const adPriorityNormal = 3
    Const adPriorityAboveNormal = 4
    Const adPriorityHighest = 5

    '---- ADCPROP_AUTORECALC_ENUM Values ----
    Const adRecalcUpFront = 0
    Const adRecalcAlways = 1

    '---- ADCPROP_UPDATERESYNC_ENUM Values ----

    '---- ADCPROP_UPDATERESYNC_ENUM Values ----

    '---- MoveRecordOptionsEnum Values ----
    Const adMoveUnspecified = -1
    Const adMoveOverWrite = 1
    Const adMoveDontUpdateLinks = 2
    Const adMoveAllowEmulation = 4

    '---- CopyRecordOptionsEnum Values ----
    Const adCopyUnspecified = -1
    Const adCopyOverWrite = 1
    Const adCopyAllowEmulation = 4
    Const adCopyNonRecursive = 2

    '---- StreamTypeEnum Values ----
    Const adTypeBinary = 1
    Const adTypeText = 2

    '---- LineSeparatorEnum Values ----
    Const adLF = 10
    Const adCR = 13
    Const adCRLF = -1

    '---- StreamOpenOptionsEnum Values ----
    Const adOpenStreamUnspecified = -1
    Const adOpenStreamAsync = 1
    Const adOpenStreamFromRecord = 4

    '---- StreamWriteEnum Values ----
    Const adWriteChar = 0
    Const adWriteLine = 1

    '---- SaveOptionsEnum Values ----
    Const adSaveCreateNotExist = 1
    Const adSaveCreateOverWrite = 2

    '---- FieldEnum Values ----
    Const adDefaultStream = -1
    Const adRecordURL = -2

    '---- StreamReadEnum Values ----
    Const adReadAll = -1
    Const adReadLine = -2

    '---- RecordTypeEnum Values ----
    Const adSimpleRecord = 0
    Const adCollectionRecord = 1
    Const adStructDoc = 2
    %>


    [文章录入员:nancy]

    相关文章
  • Invalid procedure call or argument: Chr 如何解决呢
  • ASP脚本循环语句
  • 精彩:用Asp实现QQ在线查询
  • 用ASP动态生成JavaScript的表单验证代码
  • 硬盘文件搜索代码(ASP类)
  • 文件的读出 编辑 管理
  • 怎样判断一个盘上是否有文件
  • 如何利用ASP把图片上传到数据库
  • 使用ASP建设私人搜索引擎
  • 相关书籍:
  • asp基础教材
  • ASP.NET编程常用的函数集
  • ASP函数速查手册
  • W3CSHOOL标准ASP入门教程
  • ASP中100个为什么
  • ASP经典入门之ADO基础教程
  • ASP基础简明教程
  • w3school asp电子书
  • ASP中文速查手册
  • ASP与相关数据库技术高级指南
  • 本站推荐内容

    近期主机类热搜关键词:
    美国服务器 美国服务器租用 海外服务器租用 国外服务器租用

    其它
    ASP/ASP.NET
    PHP技术
    JSP技术
    XML技术
    CGI/PERL
    WEB服务器
    WordPress专题
    其它
    电脑教程阅读排行
    ·VBScript 函数集
    ·关于SQL语句中的引号问题(VB...
    ·网站建设步骤
    ·网上建站论坛的选择和安装(菜鸟版...
    ·用ASP动态生成JavaScri...
    ·Apache+PHP+MySQL...
    ·用VBScript实现对Wind...
    ·VBScript和JavaScr...
    ·在javascript中调用vb...
    ·一个简单的javascript菜...