March 30th, 2011, 09:01 PM
Record count from query update
I'm trying to use the record count from a query update
<cfquery name="qUpdatePI" datasource="dpims-access" result="updatePIResult">
to confirm that the operation was a success:
<cfif updatePIResult.recordCount EQ 0>
but I get the error:
Element RECORDCOUNT is undefined in UPDATEPIRESULT.
What am I doing wrong?
March 30th, 2011, 09:21 PM
My stupidity! There was an error in the query thus the result wasn't built and therefore didn't exist. Corrected the query and all ok!