请问ASP通过ADO调用ORACLE数据库时不能用ADDNEW和UPDATE来新增数据是什么问题? 应当还是锁类型不对,你用rs.open sql,conn,1,2 试试 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 rs.open sql,conn,1,3锁类型不对 set rs1 = Server.CreateObject("ADODB.Recordset")rs1.ActiveConnection = MM_conn_STRINGrs1.Source = "SELECT USERNAMENO, USERNAME, PASSWORD FROM ZDWY.MEMBERRG WHERE USERNAME = '"&Request("username")&"' AND PASSWORD='"&Request("password")&"'"rs1.CursorType = 0rs1.CursorLocation = 2rs1.LockType = 3rs1.Open()rs1.addnew array("TITLE","CONTENT","USERNAMENO","USERNAME","FORUMNO"),_ //array(title,content,rs2("USERNAMENO"),username,forumno) rs1.update()已通过测试,你可以参照例子还有问题请和我联系 set rs1 = Server.CreateObject("ADODB.Recordset")rs1.ActiveConnection = MM_conn_STRINGrs1.Source = "SELECT USERNAMENO, USERNAME, PASSWORD FROM ZDWY.MEMBERRG WHERE USERNAME = '"&Request("username")&"' AND PASSWORD='"&Request("password")&"'"rs1.CursorType = 0rs1.CursorLocation = 2rs1.LockType = 3rs1.Open()rs1.addnew array("TITLE","CONTENT","USERNAMENO","USERNAME","FORUMNO"),_ array(title,content,rs2("USERNAMENO"),username,forumno)rs1.update()修改后无问题 也可以用另一种方法:set cm1 = Server.CreateObject("ADODB.Command")cm1.ActiveConnection = MM_conn_STRINGcm1.CommandType = 1cm1.CommandTimeout = 0cm1.Prepared = truecm1.CommandText="insert into ZDWY.MESSAGE (TITLE,CONTENT,USERNAMENO,USERNAME,FORUMNO)"&_"values ('"&title&"','"&content&"','"&rs1("USERNAMENO")&"','"&username&"','"&forumno&"')"cm1.Execute()set cm1.activeconnection=nothing 谢谢beckhambobo,照你的方法已解决问题. drop 表权限???????? 数据库表关联查询 求一oracle函数的写法 不能插入数据 Oracle 读取 xml视图 如何修改这条SQL语句才能实现所要求的效果~~急~~~~ 在客户端导出(exp)报错(ora816) 各位大侠,请问谁知道有没有oracle公司自己提供的认证培训? VARIABLE 用途 调用存储过程报oracle 6550 第1行 第7列 alter table 语法问题,紧急:( 急!!!怎样才能在Oracle 9i中设置大小写不敏感
锁类型不对
rs1.ActiveConnection = MM_conn_STRING
rs1.Source = "SELECT USERNAMENO, USERNAME, PASSWORD FROM ZDWY.MEMBERRG WHERE USERNAME = '"&Request("username")&"' AND PASSWORD='"&Request("password")&"'"
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 3
rs1.Open()rs1.addnew array("TITLE","CONTENT","USERNAMENO","USERNAME","FORUMNO"),_
//array(title,content,rs2("USERNAMENO"),username,forumno)
rs1.update()已通过测试,你可以参照例子
还有问题请和我联系
rs1.ActiveConnection = MM_conn_STRING
rs1.Source = "SELECT USERNAMENO, USERNAME, PASSWORD FROM ZDWY.MEMBERRG WHERE USERNAME = '"&Request("username")&"' AND PASSWORD='"&Request("password")&"'"
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 3
rs1.Open()rs1.addnew array("TITLE","CONTENT","USERNAMENO","USERNAME","FORUMNO"),_
array(title,content,rs2("USERNAMENO"),username,forumno)
rs1.update()修改后无问题
set cm1 = Server.CreateObject("ADODB.Command")
cm1.ActiveConnection = MM_conn_STRING
cm1.CommandType = 1
cm1.CommandTimeout = 0
cm1.Prepared = truecm1.CommandText="insert into ZDWY.MESSAGE (TITLE,CONTENT,USERNAMENO,USERNAME,FORUMNO)"&_
"values ('"&title&"','"&content&"','"&rs1("USERNAMENO")&"','"&username&"','"&forumno&"')"
cm1.Execute()
set cm1.activeconnection=nothing