Thank you greg for replying. I am pretty sure that there is nothing wrong with the database because the information still gets submitted in there. The way i have the cfloop now all the information still gets submitted into the database. Except, the problem is, is how it submits.
This is how it submits serial number: 1 ID:3 model no: test, test1 serial number: 2 ID:3 model no: test, test1 when it gets to the model no and rest of fields it needs to be like this serial number: 1 ID:3 model no: test serial number: 2 id:3 model no: test1 but for some reason if i try to put the Form.ID out of cfquery an into the list it just gives me the error converting data type varchar to datetime. i thought it was giving me the didn't declare error, my bad. But if i was going to do it your way, loop over the list an create a list for each column in db, how would i go about that? pretty new to coldfusion so not really sure how i would do that. again thank you for all the help i really appreciate it. >One way to troubleshoot this is to remove the <cfquery> and replace >with <cfoutput> >See what you're generating and passing to the DB.... Copy the output >and place it in your DB GUI and run it.. >You'll find out pretty quick if it's CF or the DB.. > >So you have all your fields in one huge list? >You could loop over the list and create a list for each column for your DB.. >If you know how many columns you are passing to the DB (which >apparently you do), >you could get a count of the entire list divided by the columns of your DB. >Why are you using a store proc for inserting into your DB? >Just use <cfquery>. > >Let me know if I need to explain anything else further.. > > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
