Hi All,
I want to insert multiple records at the same time, by pressing one submit
button. All the data will then "hopefully" be inserted into the table. All
the data is new. I want to create a form with many rows(which form the
records), where the columns are the fields I want to insert. I have tried
to write a CFLOOP so that all the rows have different names, i.e.
Field_One_1, Field_Two_1 and then the next row would be Field_One_2,
Field_Two_2 and so on. I would really appreciate any help you could give.I
have enclosed my CF code to give you an idea of the form which I am
generating.
Regards,
Gaurav
P.S The field #number# comes from the previous page where according to the
user I create the appropriate number of rows for him\her to enter the data.
<cfoutput>
<input type="text" name="number" value="#form.number#">
<body>
<table>
<tr>
<td><font face="Arial" size="2">ISRC Code</td>
<td><font face="Arial" size="2">Track</td>
<td><font face="Arial" size="2">Writer</td>
<td><font face="Arial" size="2">Artist</td>
<td><font face="Arial" size="2">Category</font></td></tr>
<CFLOOP INDEX="fieldnumber"
FROM="1" TO="#number#">
<tr><td><font face="Arial" size="1"><input type="text"
name="ISRC#fieldnumber#"></td><td><font face="Arial" size="1"><input
type="text" name="Track#fieldnumber#"></td><td><font face="Arial"
size="1"><input type="text" name="Writer#fieldnumber#"></td><td><font
face="Arial" size="1"><input type="text"
name="Artist#fieldnumber#"></td><td><font face="Arial" size="1"><input
type="text" name = "category" value="#category#"></td></tr>
</CFLOOP>
</cfoutput>
</table>
<input type="submit" value="Continue >>">
</form>
----------------------------------------------------------------------------
---
Demech International www.demech.net
15 Courtfield Rd, London,SW7 4DA
Tel : +44 207 370 4906 Fax: +44 207 835 1068
---------------------------------------------------------------------------
----
This e-mail and the information it contains are confidential
and may be privileged. If you have received this e-mail in
error please notify us immediately. You should not copy it
for any purpose, or disclose its contents to any other person(s).
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.