> I'd like to display a message if an update was successful. > I'm not sure how to approach this being new to CF. > > I have an UpdateDate column in my table, which is populated > by #DateFormat(Now(),"mm/dd/yyyy")# #TimeFormat(Now())# on > submission of my form. > > my flow: form > action page > updated form > > Seems like I should write a cfif that checks to see if > UpdateDate was updated in the last second of so, but I'm not > sure how to do this.
If your SQL update query doesn't return an error, that indicates your update was successful. You don't really need to do anything more to ascertain this. So, assuming that you're redirecting the user to the form, simply set a variable in the action page that can be accessed when the form page executes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
