Interpreting the complete collection of common error types of ASP

Recommended: ASP code to implement manual paged long articles
% setrecordset1=server.createobject(adodb.recordset) exec=SELECT*FROMnewswhereid=id recordset1.Openexec,conn,1,1 % tablewidth=85%border=0align=centercellpadding=3cellspacing=0 trtd ..... % IfRequest(page)=Then pageNum=0

Microsoft OLEDB Provider for ODBCDrivers (0x80040E21)-->sql statement error (data type mismatch or table name (field name) error or table is in edit state, or table does not exist in a database opened by conn)

Microsoft OLEDB Provider for ODBCDrivers (0x80040E14)-->sql statement error (field name error, or data type mismatch)

Microsoft OLEDBProviderforODBCDrivers(0x80040E07)-->sql statement error (the type of the field to be inserted or updated does not match the variable data type)

Microsoft OLEDB Provider for ODBCDrivers (0x80040E57)-->sql statement error (data to be inserted or updated overflow)

Microsoft OLEDB Provider for ODBCDrivers(0x80040E10)-->sql statement error (update field name or data type to be updated)

Microsoft OLEDB Provider for ODBCDrivers(0x80004005)-->sql statement error (the value of the field to be inserted or updated cannot be null)

Microsoft OLEDBProviderforODBCDrivers(0x80004005) --> An error occurred when opening the database, the database was not found in the specified directory

Microsoft OLEDB Provider for ODBCDrivers(0x80040E37)-->No table found

Microsoft VBscript runtime error (0x800A000D) --> Error reference to rs variable (rs object is closed or undefined)

Microsoft VBscript runtime error (0x800A01C2)-->vbscript script error (vbscript statement error)

Microsoft VBscript runtime error (0x800A0006)-->vbscript script error (overflow error)

Microsoft VBscript compiler error (0x800A040E)-->Loop is missing

Microsoft VBscript compiler error (0x800A03EA)-->If or endif is missing

Microsoft VBscript compiler error (0x800A03EE)--> Statement not ending (missed))

Microsoft VBscript compiler error (0x800A03F6)-->if statement error (missing endif)

Microsoft VBscript runtime error (0x800A005B)-->Missing set

Microsoft VBscript runtime error (0x800A0005)-->Variable not defined

Microsoft VBscript compiler error (0x800A03F9)-->if statement missing then

Microsoft VBscript compiler error (0x800A0411)-->dim statement definition error

ADODB.Recordset(0x800A0BB9)-->sql statement error (an error occurred when sql statement or conn statement is not defined or an rs attribute is assigned)

ADODB.Recordset(0x800A0CC1)-->rs object error (the rs object itself does not exist or incorrectly references a non-existent field name)

ADODB.Recordset(0x800A0BCD)-->rs object error (no records in the record set but the record set is operated)

ADODB.Recordset(0x800A0E78)-->rs object error (recordset does not exist, rs.open statement is missing)

ADODB.Recordset(0x800A0CC1) -->rs object error (references a non-existent field name)

ADODB.Recordset(0x800A0E7D)-->conn definition error

ADODB.Recordset(0x800A0CB3)-->The database is open read-only and cannot update data

Share: Asp currency capitalization conversion function
Function AtoC(a As Currency) As String 'Description: This function is suitable for currency conversions of less than one trillion yuan. The value of A is allowed to be at most two decimal places' define two strings. Here Chinese characters and numbers are calculated in one place Dim String1 As String 'Definition as follows Dim String2 As String 'Definition as follows Dim String3 As String 'From the original A