How can you send several entries to the same column for the same table at once ?
Example: I have a table called EMPLOYEES and a column for LASTNAME, FIRSTNAME .. right now the only way I know how to do it is let the user fill up the form fill up last name and first name and click send then do it again ...
how do i do it that in 1 form I can have 5 different entries for Last Name and First Name and COldFUsion will send it at once.
Ex:
PLEASE ENTER INFORMATION:
Fname:_________ Lname: _________
Fname:_________ Lname: _________
Fname:_________ Lname: _________
SEND
HERE'S MY CODE RIGHT NOW:
THIS IS THE FORM PAGE::
<form mehod="post" action="jcentry2.cfm">
<p>First Name:
<input type="TEXT" Name="fname">
<br>
Last Name:
<Input type="Text" Name="lname">
<input type="SUBMIT" VALUE="SUBMIT">
THIS IS THE CODE FOR THE INSERT/ACTION PAGE:
<Cfquery name="addjcode" datasource="Timesheets">
Insert into Jobcodes (Fname, Lname) VALUES ('#fname#', '#lname#')
</cfquery>
Please help thanks.
Example: I have a table called EMPLOYEES and a column for LASTNAME, FIRSTNAME .. right now the only way I know how to do it is let the user fill up the form fill up last name and first name and click send then do it again ...
how do i do it that in 1 form I can have 5 different entries for Last Name and First Name and COldFUsion will send it at once.
Ex:
PLEASE ENTER INFORMATION:
Fname:_________ Lname: _________
Fname:_________ Lname: _________
Fname:_________ Lname: _________
SEND
HERE'S MY CODE RIGHT NOW:
THIS IS THE FORM PAGE::
<form mehod="post" action="jcentry2.cfm">
<p>First Name:
<input type="TEXT" Name="fname">
<br>
Last Name:
<Input type="Text" Name="lname">
<input type="SUBMIT" VALUE="SUBMIT">
THIS IS THE CODE FOR THE INSERT/ACTION PAGE:
<Cfquery name="addjcode" datasource="Timesheets">
Insert into Jobcodes (Fname, Lname) VALUES ('#fname#', '#lname#')
</cfquery>
Please help thanks.