I have a textarea on a form that I want to be able to let people put a comma seperated list into, then have CF parse the input and insert all the values into a database.
I'm expecting data like:
Site Code,Site Name <return>
and then I would put it into a database of
ID (generated by database)
SalesID (given by session variable)
Site Code
Site Name
How should I do this? CFLoop the input into seperate chunks with a delimiter of CHR(10)chr(13), then loop through the chunks with an Insert?
I'm expecting data like:
Site Code,Site Name <return>
and then I would put it into a database of
ID (generated by database)
SalesID (given by session variable)
Site Code
Site Name
How should I do this? CFLoop the input into seperate chunks with a delimiter of CHR(10)chr(13), then loop through the chunks with an Insert?