Print Page | Close Window

Add multiple records to same db table

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=7157
Printed Date: 31 March 2026 at 4:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Add multiple records to same db table
Posted By: liam_conor
Subject: Add multiple records to same db table
Date Posted: 11 November 2003 at 6:38am

I am trying to add multiple records to the same table in my database. I know how to enter one recordset to my database at a time, but how do I enter multiple recordsets to the same db table. Here is what i have so far. Can anyone tell me what I am doing wrong? 

------------------------

test.asp

------------------------

<form name = "form" form method="POST" action="test2.asp">
  <p><input type="text" name="varname" size="20"><input type="text" name="varid" size="20"></p>
  <p><input type="text" name="date1" size="20"><input type="text" name="value1" size="20"><input type="text" name="notes1" size="20"></p>
  <p><input type="text" name="date2" size="20"><input type="text" name="value2" size="20"><input type="text" name="notes2" size="20"></p>
  <p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

---------------------------

test2.asp

---------------------------

DIM adoCon, mySQL

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Provider="Microsoft.Jet.OLEDB.4.0"
adoCon.Open "c:\inetpub\wwwroot\cworkman\testing\GAFKPM.mdb"

FOR i = 1 to 2

IF Request.Form(" Value" & i) > " " THEN

mySQL = " INSERT INTO Val (varid, date, value, notes) VALUES"
mySQL = mySQL & " (#" & Request.Form(" varid" ) & " #, #" & Request.Form(" date" & i) & " #, #" & Request.Form(" value" & i) & " #, #" & Request.Form(" notes" & i) & " #)"
Response.write(mySQL)
adoCon.execute(mySQL)

END IF

NEXT

adoCon.close
set adoCon=nothing




Replies:
Posted By: ljamal
Date Posted: 11 November 2003 at 7:50am
What error are you getting?

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming


Posted By: liam_conor
Date Posted: 11 November 2003 at 8:12am

I have figured it out but now I am getting a type mismatch error. I have noted it below. Can you help me?

madd.asp

---------------------

<%
vid=Request.Form("varid")
vname=Request.Form("varname")
%>
<!-- Begin form code -->
<center>

<form name="form" form method="POST" action="maddd.asp">
  <div align="center">
    <center>
    <table border="1" cellpadding="0" cellspacing="0" width="586">
      <tr>
        <td width="312" colspan="2">Variable:<input type="text" name="varname" maxlength="50"></td>
        <td width="268">Variable ID:<input type="text" name="varid" maxlength="50"></td>
      </tr>
      <tr>
        <td width="162" align="left"><b>Date: </b></td>
        <td width="148" align="left"><b>Value:</b></td>
        <td width="268" align="left"><b>Notes:</b></td>
      </tr>
      <tr>
        <font size="1">
        <td width="162"><select size="1" name="month1" style="font-size: 8pt">
        <option value="1/">1</option>
     <option value="2/">2</option>
     <option value="3/">3</option>     
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
 <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
     <option value="12/">12</option>
          </select>
          <select size="1" name="day1" style="font-size: 8pt">
 <option value="1/">1</option>
 <option value="2/">2</option>
     <option value="3/">3</option>
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
  <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
     <option value="12/">12</option>
     <option value="13/">13</option>
     <option value="14/">14</option>
 <option value="15/">15</option>
     <option value="16/">16</option>
 <option value="17/">17</option>
     <option value="18/">18</option>
 <option value="19/">19</option>
     <option value="20/">20</option>
 <option value="21/">21</option>
     <option value="22/">22</option>
     <option value="23/">23</option>
     <option value="24/">24</option>
 <option value="25/">25</option>
     <option value="26/">26</option>
 <option value="27/">27</option>
     <option value="28/">28</option>
 <option value="29/">29</option>
     <option value="30/">30</option>
 <option value="31/">31</option>
          </select>
          <select size="1" name="year1" style="font-size: 8pt">
 <option value="2003">2003</option>
     <option value="2002">2002</option>
 <option value="2001">2001</option>
     <option value="2000">2000</option>
     <option value="1999">1999</option>
     <option value="1998">1998</option>
        <option value="1997">1997</option>
        <option value="2004">2004</option>
        <option value="2005">2005</option>
          </select>
          </font>
        <td width="148"><input type="text" name="value1" size="20"></td>
        <td width="268">
        <textarea rows="1" name="notes1" cols="31" maxlength="50"></textarea>    & nbsp;    
        </td>
      </tr>
      <tr>
        <font size="1">
        <td width="162"><select size="1" name="month2" style="font-size: 8pt">
        <option value="1/">1</option>
     <option value="2/">2</option>
     <option value="3/">3</option>     
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
 <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
     <option value="12/">12</option>
          </select>
          <select size="1" name="day2" style="font-size: 8pt">
 <option value="1/">1</option>
 <option value="2/">2</option>
     <option value="3/">3</option>
     <option value="4/">4</option>
 <option value="5/">5</option>
     <option value="6/">6</option>
  <option value="7/">7</option>
     <option value="8/">8</option>
 <option value="9/">9</option>
     <option value="10/">10</option>
 <option value="11/">11</option>
&n



Posted By: liam_conor
Date Posted: 11 November 2003 at 8:23am
No need I got it...Forgive my ignorance...I am new to ASP


Posted By: fernan82
Date Posted: 11 November 2003 at 8:27pm
Next time highlight the line where you get the error as you gotta be crazy if you think somebody's gonna go thru all that code to find an error for you 

-------------
FeRnAN
http://www.danasoft.com/">



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net