Update HTML located in a specific field

  • Hello all,

    I am attempting to customize a form, whose code is kept in a field in SQL Database

    I have tried keeping things simple by just making a regular update statement like the one below, but I get a ton of errors and the update ultimately fails. I don't think a bulk insert will work for my needs, as I need to update the field not create a new one. Can someone please assist? Thank you so much!

    Begin Transaction

    Go

    Update [dbo].[HTMLFORMS]

    Set [HTML] = etc. etc. etc. and more HTML

    Where [FORMTITLE] = 'FORM NAME'

    Commit Transaction

    Go

  • Before you do the update, try to do a select and see what you are dealing with.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply