[Fygar]

okee dokee.... Hopefully one of you can tell me what's wrong. What I am trying to do is delete a certain record through ASP.

First of all I have tried a SQL string, but for some odd reason it isn't working, Here is what I have for that:

...
Conn.Execute "DELETE * FROM Problem WHERE IDNumber='" & Request.QueryString("C" & i) & "'"
...

Now do I need to use the "records effected" dealy, or something along that? or whaaaaat? And I also tried deleteing it like this...

...
Rs.Open "SELECT * FROM Problem WHERE IDNumber='" & Request.QueryString("Chk")(i) & "'", Conn, 2, 3
Rs.Delete adAffectCurrent
Rs.Close
response.Write Request.QueryString("Chk")(i)
...

If you can answer this it would be GREAT. Also if you need more info I can give it to you. Thanks in advance!

[klewlis]

Use the first one. Try taking the * out. You only need to say DELETE FROM table WHERE id = id

Also, make sure your id value is coming out the way you want it.