Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
dempster #1
Re: Updating DB from a csv file
Most text data files have one record per line. You are looping through the file
as a list and specifying the vertical tab character as a delimiter (CHR(11)).
This is probably why you are only getting one record.
I usually create a variable for CR/LF as the delimiter for text file records:
<CFSET crlf = CHR(13) & CHR(10)>
<CFLOOP List="#file_content#" Index="rc" Delimiters="#crlf#">
To test this, you may want to just output the CSV file to the browser to make
sure you are getting all the records, then go back and update the database.
-Paul
dempster Guest
-
Updating an XML file with Flash
Hi, I have just been going trough the sample application "Bike Trips Sample" Using the XMLConnector Component to upload and navigate an xml file.... -
Updating XML file using components
I am making a simple contact list application using XML. I am trying to achieve this as little coding as possible, using components. I am using the... -
Updating a text file
R. Joseph Newton wrote: >Jan Eden wrote: > >>Hi, >> >>net wrote: >> >>>I have a text file with a records like: >>> -
updating dataset from xml file
Hello, I am new in developing with Dataset, XML, Web Services ... I want to load a xml file into a dataset and update the database with new and... -
updating a File
--0-981226360-1068980951=:16169 Content-Type: text/plain; charset=us-ascii Hi, Could anyone please tell me how can I write to a file which...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
