Entering multiple records into one database

[sham_]

Hi Guys,
I have created a form that repeats the text fields. I want to record all the entries into an access database. I am trying to use the SQL Insert Command but I am receiving a mismatch criteria error. Here is the command:
Command1.CommandText = "INSERT INTO tblWeek (Classdate, Week, Day, Activity, Location) VALUES ('strDate', 'strWeek', 'strDay', 'strActivity', 'strLocation') "

Any help would be greatly appreciated

[Newsgroup_User]

If you have multiple fields with the same name, they pass a single form
value across that contains a comma delimited list.

You need to pick up this and loop through it to grab each value.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"sham!" <webforumsuser@macromedia.com> wrote in message
news:e4fd6b$a16$1@forums.macromedia.com...
> Hi Guys,
> I have created a form that repeats the text fields. I want to record all
> the
> entries into an access database. I am trying to use the SQL Insert Command
> but
> I am receiving a mismatch criteria error. Here is the command:
> Command1.CommandText = "INSERT INTO tblWeek (Classdate, Week, Day,
> Activity,
> Location) VALUES ('strDate', 'strWeek', 'strDay', 'strActivity',
> 'strLocation') "
>
> Any help would be greatly appreciated
>

[sham_]

Thanks Paul, How do I do that?

[Newsgroup_User]

The exact code depends upon what server language you are using?

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"sham!" <webforumsuser@macromedia.com> wrote in message
news:e4hqmo$elt$1@forums.macromedia.com...
> Thanks Paul, How do I do that?

[sham_]

I am using VBSCRIPT