各位帮忙啊，access的问题，我快疯了

jltx 2003-03-07 11:07:11

我用vbscript编写了一个小的管理系统，可是往数据库（access2000,ado连接）添加数据时老是提交不了。代码如下：

sql="insert news (ClassName,Title,Author,Original,Image,UpdateTime,Content,First) values "
sql=sql & "(" & "'"& ClassN& "'" & ","
sql=sql & "'"& Title &"'"&","
sql=sql & "'"& Author &"'"&","
sql=sql & "'"& Original &"'"&","
sql=sql & image &","
sql=sql & Now() & ","
sql=sql & "'"& Content &"'"&","
sql=sql & first &")"
conn.execute sql

用Response.Write (sql)把表达式写出来发现是要提交的东西，说明问题在上面的代码中。conn.execute执行更新语句时又是正常的。这到底是哪里有问题啊，各位帮忙吧。

...全文

30 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

tangbow 2003-03-07

打赏
举报

try

set rs=server.createobject("adodb.recordset")
sql="select * from bmxx"
rs.open sql,conn,3,3
rs.addnew
rs("department_id")=department_id
rs("department_name")=department_name
rs("Corporation_include")=Corporation_include
rs("department_adress")=department_adress
rs("Admin_man")= Admin_man
rs("Remarks")=Remarks
rs("Bm_tel")=Bm_tel

rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing

sheng9hhd 2003-03-07

打赏
举报

sql="insert into ....

lbd8848 2003-03-07

打赏
举报

try:
insert into news (ClassName,Title,Author,Original,Image,UpdateTime,Content,First) values "
sql=sql & "(" & "'"& ClassN& "'" & ","
sql=sql & "'"& Title &"'"&","
sql=sql & "'"& Author &"'"&","
sql=sql & "'"& Original &"'"&","
sql=sql & image &","
sql=sql & Now() & ","
sql=sql & "'"& Content &"'"&","
sql=sql & first &")"
conn.execute sql