Can anyone help me with this??

Results 1 to 2 of 2

Thread: Can anyone help me with this??

  1. #1
    Dave2000 Guest

    Default Can anyone help me with this??

    I have posted this twice and no one has been able to provide an answer. I figure that someone can help me out....<BR><BR>I&#039m trying to figure out how to do multiple inserts into a database all at once. Anyone have any ideas? I have a dynamic form in which a user selects how many records they want to insert. Let&#039s say they select 5. Once they fill out the form fields I want them to be able to submit all five of these records at once. Any pointers on how to accomplish this? Using arrays? Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Can anyone help me with this??

    You could try one of the following:<BR>A. try adding all the inserts into one SQL String i.e<BR>SQLStr = "insert into table_a Values() insert into table_a Values(), etc" <BR><BR>or <BR><BR>Open connection<BR>For I to Number of inserts<BR> Bulid sqlstr<BR> SQl.conn execute SQLstr<BR>Next I<BR>Close connection

Posting Permissions

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