View Single Post
  #3 (permalink)  
Old Nov 11th, 2004, 03:15
Monie Monie is offline
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,608
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
What if I do this...
The data wont be display...it only delete them and then redirect them to another page..."delete_success.asp"

Code: Select all
<%
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_bn_STRING
rs.Source = "DELETE *  FROM BN  WHERE bnBookDate = '" + Replace(rs__MMColParam, "'", "''") + "'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
rs_numRows = 0
response.redirect "delete_success.asp"
%>
If I want to use your code...Could you tell me where should I put them in my existing code?
Thanx .....