update 错误,请高手帮忙!!
bbs 数据库的数据出错,写个程序来更新.可是出错了.无奈请高手帮忙看看.
以下是出错的代码:
sub star6
sql="select content from forum where id=322"
set dctrs=dcconn.execute(sql)
content=dctrs("content")
content=replace(content,"[upl","<IMG src=")
content=replace(content,"oad=",chr(34))
content=replace(content,"[/",chr(34))
content=replace(content,"upload]",">")
content=replace(content,"jpg]","images/upfile/2004/")
content=replace(content,"gif]","images/upfile/2004/")
sql1="update forum set content="&content&"where id=322"
'第300行 dcconn.execute(sql1)
'response.write content
dctrs.close
end sub
错误提示:
Microsoft JET Database Engine 错误 '80040e14'
语法错误 (操作符丢失) 在查询表达式 '<IMG src="images/upfile/2004/2005949753.jpg"><IMG src="images/upfile/2004/2005949753.jpg"><IMG src="images/upfile/2004/2005949753.jpg">' 中。
/lanbei5.0.asp,行300
说明:
content 的值就是错误提示中的"查询表达式"后面那一段.
我用语句 response.write content 能成功的显示出图片,就是 update 时不能成功.
郁闷中.
谢谢高手指点.