1 Reply Latest reply on Jul 17, 2007 8:29 AM by jdeline

    cffile: reading over file

    frank_tudor Level 1
      Hi all,

      I am trying to figure out the best way to read over a file and stuff the contents into a database.

      The file contains three line blocks of customer data.

      I need to create a loop and create a condition where it reads the first three lines, then stuffs the parsed line items info into the database table, then the second group of three lines...etc.

      How would I approach this.

      I already have the cffile read part figured out now how would I loop over the 3 line condition and stuff database with parsed info?

      I am also using Coldfusion 8 so I can do a cfloop over the cffile read variable as a query, because I believe the cffile variable can be treated this way...but I could be misinformed or approaching the problem wrong.