Problem with multiple entries...

[sladewilson]

I have an ASP Application that allows members to update their info. My problem is that when they update an entry the application adds a second entry in the database instead of simply updating the intended one.

How can I make the application know to update a specific recordset. Is there some place on the web that gives a specific example of how this should be done?

 

[HowardMarks]

Use this syntax:

UPDATE yourtable SET field1 = 'This Data' WHERE ID = 'myrecordID'

Will update the specific field which matches the 'WHERE' clause (i.e. where the field id = 'myrecordID'.

If you need further clarification just ask ;-) Nick (Software Developer)

http://www.retrographics.co.uk

http://www.retrotest.co.uk

nick@retrographics.fsnet.co.uk
nick.price@myenable.com