Well i wanted to thank both of you for the help, an i was able to solve my
problem. By putting a counter in it i am able to accomplish my goal. the only
thing i got to figure out is why it doesn't put the correct information into my
2nd serial. Like it i fill out 2 serial numbers and press submit, it puts the
first line of information correct, however, where ever i have counter in my
code, instead of putting what i put for the 2nd serial it puts what i put for
the first serial.
heres an example
serial number: 61 ticket no:606 product type: all
serial number: 61 ticket no:606 prodcut type: all (although i put desktop in
here it says all like in the first one).
but here is a copy of my code in case anyone else runs into a similar problem
as me. again thank you both for helping me.
<cfloop index="x" list="#Form.serialnum#" delimiters=",">
<cfset counter=1>
<CFQUERY Name="serial" DataSource="CustomerSupport">
exec usp_CS_Insertserial
'#x#','#Form.ID#','#Form.modelno#','#ListGetAt(Form.producttype,counter)#','#Form.softhardware#',
'#Form.resolution#','#Form.resdate#','#Form.resvertified#','#Form.vertifidate#','#Form.deptvendor#','#Form.hardwarefailure#','
#Form.rma#'
</CFQUERY>
<cfset counter=counter+2>
</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:309135
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
