Member Avatar for salim

I am trying to delete a specific colum, say ProductID = 30 from table Product_tbl
now when I use server behaviour to delete, by filtering the recordset it doesn't really delete that particular ID but it goes only the next one in the row, for example:

I enter 30
the productID deleted is 29, or 28 or which ever productID it encounter.
is there anyway to solve this please.
by using filter, I use both URL and Form variable but none works, can sql solve this?

please let me know

  • 2 Contributors
  • 1 Reply
  • 71 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by madmital
Member Avatar for madmital

There's no need for a recordset if you know what row to delete.

set adoCon = server.createobject("adodb.connection")
adoCon.open "blahblah"
strSQL = "DELETE FROM Product_tbl WHERE ProductID = 30"
adoCon.Execute strSQL
adoCon.Close
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.