主题:  我的在線刪除數據記錄沒有成功!

文君

职务:普通成员
等级:1
金币:1.0
发贴:140
#12002/3/4 10:08:24
請看看我的代碼:
testing.asp
<%
Set conn=Server.createobject("Adodb.connection")
conn.open "Provider=Microsoft.jet.oledb.4.0;Data Source=" & Server.MapPath("db/Myfriend.mdb")
Set rs=Server.createobject("Adodb.Recordset")
rs.open "Select * from goodfriend",conn,1,3
if rs is nothing then
    Response.write "connection error"
    Response.end
end if
%>



New Document










<%
For i=0 to rs.fields.count-1
    Response.write ""
Next
%>

<%
rs.movefirst
do while not rs.eof
    row=""
    For i=0 to rs.fields.count-1
        row=row & ""
    Next
    Response.write row & ""
    rs.movenext
loop
%>
" & rs(i).name & "
" & rs(i) & "







pagedel.asp
<%
Set conn=Server.createobject("Adodb.connection")
conn.open "Provider=Microsoft.jet.oledb.4.0;Data Source=" & Server.MapPath("db/Myfriend.mdb")
Set rs=Server.createobject("Adodb.Recordset")
rs.open "Select * from goodfriend",conn,1,3
%>



New Document







<%
name=trim(Request("deluser"))
if name<>"" then
    Set conn=Server.createobject("Adodb.connection")
    conn.open "Provider=Microsoft.jet.oledb.4.0;Data Source=" & Server.MapPath("db/myfriend.mdb")
    Set rs1=Server.createobject("Adodb.Recordset")
    sql="delete from goodfriend where 姓名="
    sql=sql & "'" & Replace(name,"'","'") & "'"
    rs1.open sql,conn,3,2
    rs1.delete
    rs1.update
end if
%>


<%
For i=0 to rs.fields.count-1
    Response.write ""
Next
%>

<%
rs.movefirst
do while not rs.eof
    row=""
    For i=0 to rs.fields.count-1
        row=row & ""
    Next
    Response.write row & ""
    rs.movenext
loop
%>
" & rs(i).name & "
" & rs(i) & "





%>


我的思路是通過在PAGEDEL.ASP中request testing.asp中表單delid的參數,然後將其刪除,但沒有成功.這樣的做法有什麼不對?



文君

职务:普通成员
等级:1
金币:1.0
发贴:140
#22002/3/4 10:17:25
我的思路有沒有錯?如果有錯請給我正确的思路,如果沒有錯,請糾正我的語句.謝謝.



绿茶

职务:普通成员
等级:8
金币:10.0
发贴:19267
#32002/3/4 10:19:31
通过ID删除吧



vernon

职务:普通成员
等级:1
金币:1.0
发贴:172
#42002/3/4 10:20:54
见议参考
www26.brinkster.com/vernon18/default.asp
有简单的例子和源代码