Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Location
    Singapore
    Posts
    20

    Question Unanswered: ASP - Insert Multiple records

    I wanna know how to insert all the records that is checked into my SQL Server.. BUT all the records inserted is the same except for one column in my SQL Server which is the 'Partner' column..

  2. #2
    Join Date
    Jan 2003
    Posts
    26
    All the records that is checked?
    Please explain some more!

  3. #3
    Join Date
    Jun 2003
    Location
    Singapore
    Posts
    20
    Well... i have a webpage in ASP. It displays all the ringing tones on the particular tones.asp page. Currently there is no check box as I do not know how to implement the method..

    Therefore what i mean is that all the ringtones (to insert as new record in db), I have to view one by one to insert.

    What i want to know is the way on how to mass insert all the ringtones with just a single click on the button. Meaning that i checked a few check boxes, and click the button..

    You know what i mean my fren..?

    Hope you can help..

  4. #4
    Join Date
    Jun 2003
    Location
    Singapore
    Posts
    20
    BTW, its sort of like the HOTMAIL... where you checked some boxes and PUT INTO FOLDER..... bla bla bla..

    But what i want now is checked my ringtones check boxes and click a button to insert as a new record in my DB..

  5. #5
    Join Date
    Jan 2003
    Posts
    26
    Code:
    <%
    If len(trim(Request.Form("mTones"))) > 0 Then
      Dim SQLStmt, x
      SQLStmt = ""
      for x = 1 to request.form("mTones").count
        SQLStmt = SQLStmt & "INSERT INTO kek (tone) VALUES('"request.form("mTones")(x) & "';"
      next 
      conn.execute(SQLStmt)
    end if
    %>
    
    <form methos=post action=tones.asp>
      <input type=checkbox name="mTones" id="tone1">tone1
      <input type=checkbox name="mTones" id="tone2">tone2
      <input type=submit>
    </form>
    Last edited by Brimba; 07-04-03 at 07:14.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •