#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2009
    Posts
    67
    Rep Power
    5

    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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2009
    Posts
    67
    Rep Power
    5

    Solved!


    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!

IMN logo majestic logo threadwatch logo seochat tools logo