SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 05-25-2006, 03:09 AM
Sean
 
Posts: n/a
Default SQL 92 dialect question:

How do I insert multiple new records from a web form field into an MS Access database?


The way I have things setup right now I can only insert one new record at a time to the database when I would like to be able to input 10 records or so at a time before I add each one.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 05-26-2006, 05:34 AM
irfanhab irfanhab is offline
Junior Member
 
Join Date: May 2006
Posts: 10
irfanhab is on a distinguished road
Default SQL 92 answer. Re: How do I insert multiple new records from a web form field into an MS Access database?

You could make use of SQL scripts, something like:

Code:
insert into tablename values(....);
insert into tablename values(....);
insert into tablename values(....);
insert into tablename values(....);
and so on
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 07:36 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8