SENDING DATA ALL AT ONE TIME ????

[kingjjx]

hi, how do you send data at once in the same table ?
The fields in the table are Fname, Lname, Sex, Race, Age
Example:
Fname:______ Fname:_____
Lname:______ Lname:_____
Sex:___ Sex:___
Race:___ Race:____
Age:___ Age:____

Fname:______ Fname:_____
Lname:______ Lname:_____
Sex:___ Sex:___
Race:___ Race:____
Age:___ Age:____
[SUBMIT]

Please help
thanks
-jon

 

[cfk]

I'm not sure what you want, but it may be this.

<!--- Form to be submited --->

<form action=&quot;nextpage.cfm?total=10&quot; method=&quot;post&quot;>
<table cellpadding=0 cellspacing=0 border=0>
<cfloop index=&quot;index&quot; from=&quot;1&quot; to=&quot;10&quot;>
<tr>
<td>FName</td>
<td><input type=&quot;text&quot; name=&quot;FName_#index#&quot;>
<td>LName</td>
<td><input type=&quot;text&quot; name=&quot;LName_#index#&quot;>
<td>Sex</td>
<td><input type=&quot;text&quot; name=&quot;Sex_#index#&quot;>
<td>Race</td>
<td><input type=&quot;text&quot; name=&quot;Race_#index#&quot;>
<td>Age</td>
<td><input type=&quot;text&quot; name=&quot;Age_#index#&quot;>
</tr>
</cfloop>
</table>
</form>


<!--- INSERT Page For ACCESS level DB --->

<cfloop index=&quot;index&quot; from=&quot;1&quot; to=&quot;#url.total#&quot;>
<cfquery datasource=&quot;myDB&quot;>
INSERT INTO myTable(FName,LName,Sex,Race,Age)
VALUES(
'#EVALUATE(&quot;FROM.FName&quot;&index)#',
'#EVALUATE(&quot;FROM.LName&quot;&index)#',
'#EVALUATE(&quot;FROM.Sex&quot;&index)#',
'#EVALUATE(&quot;FROM.Race&quot;&index)#',
#EVALUATE(&quot;FROM.Age&quot;&index)#
)
</cfquery>
</cfloop>

<!--- INSERT Page For MSSQL2K level DB --->
<cfquery datasource=&quot;myDB&quot;>
<cfloop index=&quot;index&quot; from=&quot;1&quot; to=&quot;#url.total#&quot;>
INSERT INTO myTable(FName,LName,Sex,Race,Age)
VALUES(
'#EVALUATE(&quot;FROM.FName&quot;&index)#',
'#EVALUATE(&quot;FROM.LName&quot;&index)#',
'#EVALUATE(&quot;FROM.Sex&quot;&index)#',
'#EVALUATE(&quot;FROM.Race&quot;&index)#',
#EVALUATE(&quot;FROM.Age&quot;&index)#
)
</cfloop>
</cfquery>

The difference between the two DB types
is in MSSQL2K you can send all your info
in one database call making the code
more efficiant.

Hope this is what you are after.

 

[kingjjx]

Hey, what does this part of the code do ??

<cfloop index=&quot;index&quot; from=&quot;1&quot; to=&quot;10&quot;>

when you say .. from=&quot;1&quot; to=&quot;10&quot;
can I change this figures ? what would be affected ?
thanks
-jon

 

[kingjjx]

hey .. in this line ..'#EVALUATE(&quot;FROM.FName&quot;&index)#',
did you mean to say FROM.Fname or FORM.Fname ???

thanks
-jon

 

[kingjjx]

hey, i tried the code .. it doesnt work .. can you adivce what could be wrong ..
its at :

http://dynamic.dynojet.com/CFML/timesheetdb/trial1.cfm

 

[kingjjx]

hey dude, where are you ? help me out please !!!

 

[ktucci]

try: <cfloop index=&quot;index&quot; from=&quot;1&quot; to=&quot;2&quot;>