Skip to main content
U
uandme72
Known Participant
January 12, 2010
질문

How to Insert more than one record at a time- with fixed set of values in one field

  • January 12, 2010
  • 2 답변들
  • 2005 조회

Can someone guide as to how to insert multiple records at a time using ASP VBScript in Dreamweaver CS4 or ADDT.

If someone can guide then the exact problem is given below.

I have a MS access database with one table. The table has three fields. The first field is an autonumber field for ID number.

The second field contains string values- One out of 7 predefined values. One set of records consists of 7 records containing all the seven types of predefined values in fields no 1.

The third field is a numeric field and can contain integers.

I want that the user can enter data for the table using an ASP form in such a way that he enters one set of records at a time in one single screen. This way he will not have to remember that he has /has not entered all the seven set of values for the field no 1.

I am not creating fields with the 7 types of field1value as their names as it will increase the number of fields drastically.

Please help for dreamweaver ASP VBScript.

이 주제는 답변이 닫혔습니다.

2 답변

B
bregent
Participating Frequently
January 12, 2010

You would create a form with fields for all 7 rows. Submit the form to the ASP script which will then generate an insert statement for each row.

I'm not exactly sure what your difficulty is, or what you mean in your subject line "with a fixed set of values in one field". It's probably best to provide some example data.

U
uandme72작성자
Known Participant
January 13, 2010

Exactly how do I create the ASP script for inserting multiple records in one operation from one form.

Kindly guide me considering the dreamweaver environment.

B
bregent
Participating Frequently
January 13, 2010

>Exactly how do I create the ASP script for

>inserting multiple records in one operation from one form.

What level of experience do you have with ASP? Which language are you using with it (VB or JS)?

>Kindly guide me considering the dreamweaver environment.

The Dreamweaver environment is not a consideration for this...what you want to achieve falls outside of DW's capabilities. You need to code this by hand.

P
poneacre
Participating Frequently
January 12, 2010

Use a form.  I suggest you find some tutorials out on the web for this basic process of INSERTing a record.  First stop is your dreamweaver help and then at adobe.com.

약관 및 조건Accessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices