# How can I delete the default record in asp

**URL:** <https://forum.kirupa.com/t/how-can-i-delete-the-default-record-in-asp/29468>\
**Category:** Uncategorized\
**Created:** [August 27, 2003, 5:41am UTC](https://forum.kirupa.com/t/how-can-i-delete-the-default-record-in-asp/29468 "2003-08-27T05:41:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SBUH](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@SBUH](https://forum.kirupa.com/u/SBUH)\
**Post date:** [August 27, 2003, 5:41am UTC](https://forum.kirupa.com/t/how-can-i-delete-the-default-record-in-asp/29468/1 "2003-08-27T05:41:49Z")

</div>

hello, my situation is here in my asp page,  
…  
set rs=Server.CreateObject(“ADODB.recordset”)  
sql=“select \* from Tshirtproduct where cus\_id=’”&session(“ID”)&"’"  
rs.Open sql,Conn  
do until rs.EOF  
…

```
          response.write("Remove")---I need to make it work
         
          response.write("Tshirt View")
         
        response.write(rs("quantityL"))
          
          response.write(rs("totalprice"))
         
          response.write(rs("systime"))

```

response.write(rs(“confirm”))-----this is the condition col.

…  
rs.MoveNext

loop  
rs.close  
conn.close

…  
I want to make the “remove” works-----delete this record when "confirm " value is 0 in MS SQL 2000.

Plz help me! Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 28, 2003, 2:05am UTC](https://forum.kirupa.com/t/how-can-i-delete-the-default-record-in-asp/29468/2 "2003-08-28T02:05:25Z")

</div>

Something like this should work

```php

<% @ Language = "VBScript" %>

  <% Dim conn %>
  <%
Set conn = server.createobject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("yourdb.mdb")
sql="select * from Tshirtproduct where cus_id='"&session("ID")&"'"
sqlDelete = "DELETE FROM main WHERE confirm = ' 0 ' "
    
rs.Open sql,sqlDelete, conn
%>

```

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 28, 2003, 8:34am UTC](https://forum.kirupa.com/t/how-can-i-delete-the-default-record-in-asp/29468/3 "2003-08-28T08:34:22Z")

</div>

hello, we only have the response.write(“remove”) on the page. Then how can we connect with this vb script to make it work when the user click the remove words ? thanks!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 28, 2003, 10:12am UTC](https://forum.kirupa.com/t/how-can-i-delete-the-default-record-in-asp/29468/4 "2003-08-28T10:12:34Z")

</div>

how about something like this?

if rs(“confirm”)=“0” then

```
  response.write("Remove")

  end if 

```

and I want to make a popup window for those have “remove”, how to make it show the popup window showing the message  
" are you sure to delete it  
Yes No"  
?