i am currently using frontpage to access, edit, update, delete, etc.. my database. i used the dbw to make some sample pages, went back in and customized them. the problem i am running into now is i tried adding the main field that was being edited so i can edit that part of the record. heres the 4 fields in the 1 table.
description, unit, location, price
the original edit.asp was queryed by the description and it edited the rest of the 3 fields correctly. i tried adding a description field to the edit.asp page, it querys it fine, i get the exact same info from the previous page, but when i go to click the update nothing now will update. if anyone ever tried doing this before and had some success, i would appreciate any help.
heres the page layout.
i start in the database_editor (added a custom search, works), then it brings up the lists.asp, click on that and switches the frame page for the detail.asp, when i click on edit, i get the edit.asp page (now with my custom description field added). then when i click ok i get my page that says it has been successfully added, the update.asp page. then wehn i go back to that record i updated, nothing is updated in any of the fields. i check all references to the description fields, and am not sure what page exactly i should be checking. edit.asp or update.asp?
sidenote: every other function of the site still works.