Multiple Insert into DB

Results 1 to 2 of 2

Thread: Multiple Insert into DB

  1. #1
    Aran Guest

    Default Multiple Insert into DB

    Hi I know how to bring up multiple records from a db over a specific time period but I was wondering if anyone knew how to do the same for inserting multiple entries over a time period, i.e. if a client books for several days how can I insert their data (into an access 97 db)without having to repeat the action for each different day given that date is the only changing column.<BR>hope this makes sense,<BR>tia,<BR>aran

  2. #2
    Join Date
    Dec 1969

    Default You can't...

    The SQL INSERT INTO statement can *only* insert one record.<BR><BR>You need to either use a stored query or just loop in the ASP code.<BR><BR>

Posting Permissions

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