in reply to Re: UPDATE not working with MS SQL Server
in thread UPDATE not working with MS SQL Server

I spotted my problem ... of course, after I posted here.

The code shared in my post is clean. The problem is in my SQL schema. There was a field name mismatch.

All is working fine now.

  • Comment on Re^2: UPDATE not working with MS SQL Server

Replies are listed 'Best First'.
Re^3: UPDATE not working with MS SQL Server
by johnny_carlos (Scribe) on Nov 04, 2011 at 17:25 UTC
    It's good practice to use the die statement, especially with databases, as it probably would have informed you of a bad column name.

      Or set RaiseError, which would make it die automatically in case of error...