I've got several form variables
I'm putting these into a database with an update query that gets looped over, personnumber is the index and I need form.firstname1 to update the number in the form variable name.Code:form.firstname form.firstname1 form.firstname2 form.firstname3 ect.....
Code:INSERT INTO golf (First_Name) VALUES <cfqueryparam CFSQLType="cf_sql_varchar" value="#Encrypt(FirstName & personNumber,'AES', 'HEX')#" />
This query will run but it will encrypt form.firstname and append the number to it in a string so you'll get a value like Laura2, Laura3.
I've tried EVALUATE and VARIABLE but both throw an error:
i've used evaluate and variable to do this in the past but for some reason the encrypt function seems to be gumming up the works.