Replies Back to Article

Update Multiple Records with SQL Update and Where/In Clause

Amazing...
January 21, 2004 by ed hidden
Thank you for such a great tutorial. Very simple to follow and with how little code is actually here, it's incredibly simple to tailor for specific uses. Thank you for taking the time to put this out here for us. I have used other methods to do this previously, but actually follow and easily understand what is happening here!!!!
Update Multiple Records
March 22, 2007 by Shields Dana

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.