Hello,
I have a form that contains muliple records of text fields. The values in some of the fields contain "commas". The form allows users to update these multiple records by pressing a SAVE button. In my savedata.cfm template, I put these records into an array. I also have an associated array which contain the pkey. I populate the array using the below code:
<!--- Start Code
<cfset idx = 1>
<cfloop index="requirement" list="#theRequirement#" delimiters="|">
<cfset LineItemArray[idx] = #requirement#>
<cfset idx = idx + 1>
</cfloop>
---> End
Problem is that the records I am trying to save have commas in them.
Finally the question, how does one change the delimiter passed into this savedata.cfm module to another value like "|".
Thanks,
Mike
I have a form that contains muliple records of text fields. The values in some of the fields contain "commas". The form allows users to update these multiple records by pressing a SAVE button. In my savedata.cfm template, I put these records into an array. I also have an associated array which contain the pkey. I populate the array using the below code:
<!--- Start Code
<cfset idx = 1>
<cfloop index="requirement" list="#theRequirement#" delimiters="|">
<cfset LineItemArray[idx] = #requirement#>
<cfset idx = idx + 1>
</cfloop>
---> End
Problem is that the records I am trying to save have commas in them.
Finally the question, how does one change the delimiter passed into this savedata.cfm module to another value like "|".
Thanks,
Mike