I searched the list archives, and a while back, Jim Griggs on this list asked for some STM script assistance for doing an SQL UPDATE. I did not see any solutions to this, so here is the problem:
An STM page is returned as a web form with a tabular array of records from a database. For example: We'll call the following page records_to_update.stm Part | In Stock foo1 [x] foo2 [ ] foo3 [x] [UPDATE STOCK] What I need to do is an SQL UPDATE invoked from the [UPDATE STOCK] button that would update all the records, depending on the form checkbox. If I check foo2, and uncheck foo3, the database would be updated and if I come back to records_to_update.stm and did a RELOAD of the page, I would now have: Part | In Stock foo1 [x] foo2 [x] foo3 [ ] I have been trying out the RCwhile with the RCQ stuff without any success. I'm sure some of you folks have some sample script that could handle this. Thanks for help. Michel ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
