5
明天又找出了一个小毛病
conn.execute "select * from users where nickname="亮亮" "
能找出这句话的毛病吗>?
准确的应当是如许
conn.execute "select * from users where nickname='亮亮' "
也就是说("")双引号外面相对不克不及再直接套双引号了。
6
又呈现了一个级其令我愁闷的毛病,唉
Microsoft OLE DB Provider for ODBC Drivers 毛病 '80040e07'
[Microsoft][ODBC Microsoft Access Driver] 尺度表达式中数据类型不婚配。
/myforum/look.asp,行8
源码以下:
dim rs_content,sql,articlenum
articlenum=request("num")
session("articlenum")=articlenum
set rs_content=server.CreateObject("adodb.recordset")
rs_content.open "select * from articlebay where articlenum='" &articlenum&"' ",conn,3 !!!!!!!!!!!!
!!!!!!!!!!暗示第8行,改成
rs_content.open "select * from articlebay where articlenum=articlenum ",conn,3 就行了,愁闷,why?
7
明天又呈现了一个毛病,是甚么呢?是如许
num=session("articlenum")
sql="insert into revertbay (articlenum,revertauthor,reverttopic,revertcontent,expression,revertdate,reverttime) values