FRONTPAGE 2000 (Updating and Deleting Records in Access)

[jbento]

All,
I have a Microsoft Access Database on my server, and it is connected. I use Microsoft FRONTPAGE 2000 to do editing to the site. I have created a submission.asp form and results page, and they work fine. I have a table named "tbl_Assignments" and the fields in that table are "ID, dateMonday, mathMonday, readingMonday, writingMonday, scienceMonday, and otherMonday". I would like to create a update.asp/delete.asp page to update from a webpage. Could anyone give me the correct UPDATE SQL AND DELETE SQL statements to use for this? I know the code goes into the Database Results Wizard Step 2 area, under Custom Query in FRONTPAGE. This help would be greatly appreciated. Thanks

 

[DRowland]

Here's what I use to update my page...
----------
"UPDATE bbb SET bbb.inqcount = [inqcount]+1, bbb.lastinq =Now() WHERE bbb.compid = '" & getrpt & "' ; "
-----------

It increases the number in the field bbb.inqcount by one, each time it finds a file what matches the value of "getrpt".

One thing to be sure of is that you will only update one file at a time, under normal circumstances. So you want to be sure that you use a field with no duplications in the rest of the database.

Hope that helps..

 

[jbento]

Thanks Drowland for responding. I figured it out awhile ago, but thanks again for responding.

Jerome