Yes convert it to cfquery with updates- it's a good place to start. I have found a lot less problems when I use the more generic tags (e.g. form vs cfform/cfupdate vs cfquery & update/etc) My issue was browser based- ie what looked pretty/worked great on pc didn't always do the same with macs. Less worries in the long run. -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 9:02 AM To: CF-Talk Subject: CFUPDATE and MySQL Im porting an application from Access to a MySql database. MySql does not like the CFUPDATE tag. I have seen this strange error if i submit a form that does not update the database (the form passes the exact same data that is inside the row (nothing changes)). Error Diagnostic Information SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. Should i convert all the CFUPDATES to CFQUERY with UPDATE? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
