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

Reply via email to