Trying to loop and INSERT multiple records from Excel (error!)

Hi all, I've created a page that consumes an Excel spreadsheet, loops over the rows, and dynamically creates a pre-populated form. The idea being that folks inputting data have an intermediate step to clean up the data before inserting it into the DB. That all works just fine. When I POST the

Re: Trying to loop and INSERT multiple records from Excel (error!)

Leigh, Thanks - uhhh...yes, overlooked that part didn't I? Here's what I have so far - not all of my validation is place but I need to get this to work first:

Re: Trying to loop and INSERT multiple records from Excel (error!)

> > > > > > > > Wait a second... > > You have got a cfquery, nested within another cfquery. That is what is > causing the problem. > > Thanks, Leigh. I knew I needed a second set of eyes. I was under the impression that I could do that for whatever reason (I don