Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Entering multiple records into one database

New Here ,
May 17, 2006 May 17, 2006
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
TOPICS
Server side applications
339
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 17, 2006 May 17, 2006
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
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 18, 2006 May 18, 2006
Thanks Paul, How do I do that?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 18, 2006 May 18, 2006
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?


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 22, 2006 May 22, 2006
LATEST
I am using VBSCRIPT
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines