1 Replies - 1758 Views - Last Post: 04 April 2002 - 09:59 AM Rate Topic: -----

#1 Fygar  Icon User is offline

  • I liek milk!!1
  • member icon

Reputation: 6
  • View blog
  • Posts: 4,361
  • Joined: 28-March 02

Recordset question....

Posted 28 March 2002 - 02:38 PM

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!


Is This A Good Question/Topic? 0
  • +

Replies To: Recordset question....

#2 klewlis  Icon User is offline

  • cur tu me vexas?

Reputation: 8
  • View blog
  • Posts: 1,723
  • Joined: 09-November 01

Re: Recordset question....

Posted 04 April 2002 - 09:59 AM

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.

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1