Affected Rows on Update in MySQL

Hello everyone

How can I retrieve the amount of changed Records on an update in MySQL-Tables? In PHP for example, ther's a function named "affected_rows()", is there something similar for ColdFusion or do we have to resolve this problem over storedprocedures.

I only have to know if an update was made or not, it isn't important to know the exact amount of the affected rows.

thanks a lot in advance
chris.w.

anyone who is interested to solve that problem, I've found a solution. But the only way to get the affecte_rows, is to work with the java-native-database-driver and the cfscript-tag.

Example:
URL

For most RDBMS's, stored procs are the best way to get data back regarding DML queries (insert, update, delete).

That said, some support getting this info back natively (SQL Server, Oracle, etc...obviously MySQL does as well) For example, you can get the id of the row just inserted from SQL Server by returning @@IDENTITY. But this is all DB-specific.