Problem with a simple update query - Update value in row from value in previous identical row

  • The incorrect e-mail address would be updated via an asp edit page.

    Is the asp edit page talking to the database? What kind of query is being used to update this one record? Is there an update button you can click to change this one email address? What code do you have in the Button Click event handler?

    What I am saying is you can use the query Lynn had posted earlier, in the code behind the asp edit page and it will update all records in one go. Also since the only columns in the table are FirstName, LastName and EmailAddr there is no way ASP page knows which single record to update in the table.

    Am I making any sense?

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply