Insert/Update multiple values

Results 1 to 2 of 2

Thread: Insert/Update multiple values

  1. #1
    Join Date
    Dec 1969

    Default Insert/Update multiple values

    How do I insert/update values of a combo box with a property of "multiple" (<select name=sID multiple>)?

  2. #2
    Join Date
    Dec 1969

    Default RE: Insert/Update multiple values

    this is a nifty one.<BR><BR>you loop through the values passed across, inserting them as you go.<BR><BR>i.e.<BR><BR>for each item in request.form("multipleselect")<BR> &#039 sql operation<BR>next<BR><BR>if you can, speed this up as much as possible. normalize your database with this in mind, use a stored procedure, use adExecuteNoRecords, keep your code tight and don&#039t put anything inside the loop except the .execute() call<BR><BR>j

Posting Permissions

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