Skip to main content
Participating Frequently
May 6, 2010
Question

Upating Records

  • May 6, 2010
  • 1 reply
  • 358 views

How delete records

in extisting table and place updated records in coldfusion.

    This topic has been closed for replies.

    1 reply

    May 6, 2010

    hi ColdfuisonDB2,

                          hope you need to remove existing data and inserts the new data there, for that you just use update statement..

    example

              update your_tablename

              set

                   column_1=newvalue1

                  , column_2=newvalue2

                  ......

                  .....  

                 ,columm_n=newvaluen

              where record_id=id

    hope it helps...

    thanks