This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » ASP » Insert Multiple Rows MSSQL

Insert Multiple Rows MSSQL
Carl Evans Member Since: 28 Sep 2001 Posts: 7	Posted 28 May 2010 14:54:46 Hi, I need to insert multiple rows into an MSSQL database using Classic ASP and VBScript. Using CS4 behaviours I can only insert one row at a time. I am producing a cricket website where I need to add a scorecard, and adding one player at a time is time consuming, so I need to add up to 11 rows (players) from one form submit. Can anyone point me in the right direction? Carl Hi, I need to insert multiple rows into an MSSQL database using Classic ASP and VBScript. Using CS4 behaviours I can only insert one row at a time. I am producing a cricket website where I need to add a scorecard, and adding one player at a time is time consuming, so I need to add up to 11 rows (players) from one form submit. Can anyone point me in the right direction? Carl

Insert Multiple Rows MSSQL

Carl Evans
Member

Since: 28 Sep 2001
Posts: 7

Posted 28 May 2010 14:54:46

Hi,
I need to insert multiple rows into an MSSQL database using Classic ASP and VBScript. Using CS4 behaviours I can only insert one row at a time. I am producing a cricket website where I need to add a scorecard, and adding one player at a time is time consuming, so I need to add up to 11 rows (players) from one form submit.

Can anyone point me in the right direction? Carl

Hi,
I need to insert multiple rows into an MSSQL database using Classic ASP and VBScript. Using CS4 behaviours I can only insert one row at a time. I am producing a cricket website where I need to add a scorecard, and adding one player at a time is time consuming, so I need to add up to 11 rows (players) from one form submit.

Can anyone point me in the right direction? Carl

Seb Adlington
Freaking Member

Since: 09 Aug 2001
Posts: 104

Replied 03 Jun 2010 12:55:10

hi Carl,

You will have to get your hands dirty and edit the sql code by hand - you are also going to have to loop through the fields on your form to see how many have been filled in - if this sounds outside your comfort zone I would recommend you get googling - here is a good place to start
CS4 behaviours can't do this on its own.

www.drdev.net/article01.asp

Cheers

Seb

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!