Asp update and delete sql statement

[Tech718]

Hi,
i have a user site and i am trying to make users able to update and delete their posts but i have the same issue with both. Whenever i update or delete it happens to all their postings instead of just one of their postings.
I want all their postings to show up but for them to be able to select the ones they want to update or delete from the results. Help me please!

For the update i tried
UPDATE "table"
SET column1 = [column1], column2 = [column2]
WHERE UID = '::uid::'

and for the delete DELETE FROM table
WHERE UID = '::uid::'

 

[PHV]

You should have a Primary Key in your table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lespaul]

that's because you're only criteria is the userid...when you run the query it finds all the records that meet that criteria (all the user's postings) and does what you've told it to do (update or delete)...how can you identify the EXACT record you want to update or delete?

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com