ODBC guide

Update ticket with HTML comment


Adds an HTML-formatted comment to an existing ticket and updates its status. This example demonstrates setting comment_body_html in the UPDATE statement.

Update Tickets 
SET comment_body_html='Closing <b>this</b> ticket'
  , status='solved' --pending, new, closed
  --, comment_author_id=123545   
  --, comment_public = 0 --or 1  
Where Id = 1234