0

hi! please help am still new on ASP and am having trouble deleting from a table please help. the code i used is this:

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLNCLI;Server=THABO-2A88C6501\SQLEXPRESS;Database=customers;User ID=sa;Password=thabo;"
set rs=Server.CreateObject("ADODB.recordset")

if request("Delete")="Delete" then
sql="DELETE * FROM Details WHERE Cust_ID='4567'"
end if%>
<center><form method="post" action="Delete.asp">

<input type="submit" name="Delete" value="Delete">
</form></center>

<%
conn.close
%>

please correct and show me what am doing wrong thanx in advance

Edited by PotaZinga: n/a

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by PotaZinga
0

oh ya i saw that just i dint know where or y my code wasn't working and dint really give me any errors.but i did find what my problem was just a few min after i posted. i had left out the

conn.Execute sql

code thanx anyways

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.