Inserting form variables in a databse

[ColdfuisonDB2]

I need to store

user entered form values in a database.

I need to delete extisiting records before loading these values

how can I do it in coldfusion7

I was examining a file it was using this

Artist_desc                  = '#FORM["Artist#'i#"]'

what does it mean

[ilssac]

Artist_Desc is a field in a database.

A form has been submitted that has multiple fields named 'Artist' and numbered consecutively.  I.E. Artist1, Artist2, Artist3, etc.

The developer used array notation to dynamically reference these form fields with the string "Artist" and a variable 'i'.

There seems to be a syntax error in the code sample you provided, that double(") quotes, single(') quotes and hash(#) marks do not seem properly nested to me.