Member Avatar for PotaZinga

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 because: n/a
  • 2 Contributors
  • 2 Replies
  • 101 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by PotaZinga
Member Avatar for ArtistScope

You should do a search before posting because this was answered only a few days ago.

Member Avatar for PotaZinga

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.