Rachel, Can you <cfdump var="#form#"> the form scope and paste the output into a message? It would help to see how the form data is constructed.
Carl Rachel B 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:309098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
