1. Open again before the record set is turned off: ---------------------------------- SQL = "SELECT * From test "RS.Open SQL, CONN, 1, 1 if not = rs (" name ") end if sql =" select * from mybook "rs.open SQL, CONN, 1, 1 ------------------------------------ Solution: Turn the RS before the second RS.Open. Close or Set RS1 = Server.createObject Rs1.open SQL, CONN, 1, 1 2, Table name or field name with SQL keyword ---------------------------------------------------------------------------------------- ----------------- SQL = "Select * from user" rs.open SQL, CONN, 1, 1 --------------- ---------------------- User Solution to SQL Keyword: Change to SQL = "SELECT * FROM [USER]" 3, use the lock mode to perform Update - ------------------------------------ SQL = "SELECT * from [user]" rs.open sql , CONN, 1, 1 RS.ADDNEW or RS ("UserName") = "aa" rs.Update --------------------------- ---------- Current record set open mode for read-only resolution: change to RS.Open SQL, CONN, 1, 3 4, the comparative field value used in the query statement does not match the field type - --------------------------------------- SQL = "Select * from [user] where id = "& myid &" "RS.Open SQL, CONN, 1, 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ -------- The design ID is a digital model in the table, then mistakes.
