19 Replies Latest reply: Jul 19, 2010 12:16 PM by JR "Bob" Dobbs RSS

    How do I tell if a mysql update was successful?

    sean69 Community Member

      How do I tell if a mysql update was successful?

      I need to know if an update was run or if the record was not found....  is there some way that coldfusion can use that traps success/fail resoponses from mysql [linda like myquery.RecordCount ]?

       

      basically I am trying to update a row, if no row was updated - the record must not exist so I then need to do an insert...

       

      -any ideas?

       

      -sean