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.. On Tue, Jul 15, 2008 at 9:09 AM, Rachel B <[EMAIL PROTECTED]> wrote: > Hey Everyone, > > well i been trying to figure this out for days but i am having no luck. In my > form i am able to add multiple serial numbers an it all goes into the > database with no problems. However, i need every serial number i add to > create a new field an not go into the same field > > This is how it is going in there now > serial number: 1234,223 next field: blah, blah2 > > an i need it to go into my database like > serial number: 1234 next field: blah > serial number: 223 next field: blah2 > > to accomplish this i been trying to loop over a list.Right now i am able to > make the first field in my form (Form.serialnum) accomplish this. However, i > can not get the rest of the fields to do this because of Form.ID. If i try to > put the Form.ID in my list it says that i didn't declare it. however, if i > leave it in my cfquery it works except it doesn't put any of the fields past > ID into the database like i need it to. I admit i am not the best at > coldfusion and i been trying, but i am just lost on where to go at this > point. If you could tell me what i am doing wrong or have any suggestions i > would very much appreciate it. The code i been trying it below > > Thank you to all who help. > > <cfloop index="x" list="#Form.serialnum#" delimiters=","> > <CFQUERY Name="serial" DataSource="CustomerSupport"> > exec usp_CS_Insertserial > '#x#','#Form.ID#','#Form.modelno#','#Form.producttype#','#Form.softhardware#', > '#Form.resolution#','#Form.resdate#','#Form.resvertified#','#Form.vertifidate#', > '#Form.deptvendor#','#Form.hardwarefailure#','#Form.rma#' > </CFQUERY> > </CFLOOP> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:309065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
