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:309063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
