Insert Multiple records at the same time to ms access database through asp page that has sql?

Question

okay, here it is... my form has three text boxes and one radio group: the 1st is called "name", the second is called "title", the third is called "dateSubmitted" and the fourth is a radio button which lets you chose the recurrence and they are [monthly] and the other [once] is the user fills out the forms and selects monthly i want the asp code to insert the form data 12 times, for example is someone fills the form and submits with MONTHLY RECURRENCE SELECTED i want my MS ACCESS table to look like this


max , do this , 1/1/2006 , monthly
max , do this , 2/1/2006 , monthly
max , do this , 3/1/2006 , monthly
max , do this , 4/1/2006 , monthly
max , do this , 5/1/2006 , monthly
max , do this , 6/1/2006 , monthly
max , do this , 7/1/2006 , monthly
max , do this , 8/1/2006 , monthly
max , do this , 9/1/2006 , monthly
max , do this , 10/1/2006 , monthly
max ,

Answer 1

Add a switch statement in the ASP code that uses the radio button response. For each case you can set a variable to be a string for example monthly yearly and so on. Then you just need to include that variable in your SQL statement in the value for the right field. Any more questions and you can email me at: [e-mail]

Answer 2

I basically prevalent with Hostmonster's technical help that they haven't any difficult shrink on the database length, so which you would be locate with 2gigs or extra. i've got been making use of them for countless years on a internet site that gets over 5000 travelers each and every day, and that they have got been tops to artwork with. i exploit Drupal for the area, which runs on very own domicile page and in addition they help Frontpage extensions for asp.