Replies Back to Article
Update Multiple Records with SQL Update and Where/In Clause
I don't think this tutorial is disappointing because it's poorly written; in fact, it's an easy, simple tutorial to follow, especially if you're not adept with writing code and purchased Ultradev/Dreamweaver specifically for that reason.
However, it addresses only a situation where a recordset is updated to the identical value; this is far rarer than a multiple recordset update where each record is updated differently. Currently, using Ultradev's functionality, you have to have a submit button on each and every record. So, for example, if I have a repeating region of addresses and I want to update the ZIP Code column to a different value for each record, I have to submit the button for each record.
I've seen some tutorials that try to address looped recordset updates, but I'm sort of confounded that such a common task--I.E. your online banking allows you to do this--is completely missed in Ultradev/Dreamweaver core functionality. No functionality, no extensions. Just extraordinarily complicated code tutorials that I can't understand.
I mean if you pay this much for software, you'd think it would include such basic functionality.
I have ultradev 4.0. Do the newert versions of Dreamweaver feature this functionality. Again, to me, it seems like such a core thing.