On 2/20/07, Judah McAuley <[EMAIL PROTECTED]> wrote: > > Dave Watts wrote: > >>>> I shouldn't complain too much, as they don't care how > >>>> much it costs and pay quickly - but, is there a more > >>>> efficient way of doing this? > >>> triggers. > >> AJAX. Field-based editing with a simple log. =] > > > > I'm sorry, but that, by itself, is a very silly answer. > > > > AJAX is display technology. It lets you build a more responsive, less > linear > > presentation layer. It doesn't let you track database changes any more > than > > a traditional HTML interface lets you track database changes. > > I agree that it is certainly an incomplete answer. I suspect what the > poster meant was to attach an onChange call to all the fields on the > form that are being used to display and change data. Have the call do an > async request to the server with the field id, before value and after > value that gets fed into a logging function. For validation purposes, I > would also add the id of that field to a hidden form field listing the > fields that were changed and then compare the changed values to the > original values that were sent out. That step, however, could just > replace the Ajax bit entirely.
Not bad. Little more complex than I was thinking- Most JS libs worth their salt have in-line editing type deals (where you're in a "view" and you click on a field, say the "First Name" field, and it becomes a text-box so that you can edit content)- aside from the first insert, how often is /every/ field changed? That's the beauty of AJAX, or at least part of it-- you only need to send the data you need. So basically, you handle every field edit (aside from the first insert) individually. You can use nice little JS stuff that instantly tells someone if they've entered a bad value (using the server, mind- not client JS code) and whatnot. Since you're doing everything "piecemeal" soto speak, adding a "logger" is a piece of cake. It's already broken down into little bits, see. That's basically what I was thinking. AJAX is FAR from a "display" technology*. Far far far. But I do love my fancy fades and whatnot. :-) *this is one of my main issues with MVC "design"-- the UI can have a HUGE effect on the app-- huge! Hard to split everything into dispirit parts, ya know? Bah. Now that was a poor expression of whatever I meant. =-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

