RE: Multiple forms, looping and inserting

Similar to Matt's solution, but name your Form fields with a numeric extension input type=text name=Name_#i# value=#HTMLeditFormat(Form[Name_#i#])# Then when you're inserting, just use the form[Name_#i#] Remember to pass the number of entries along with the form, otherwise you won't know how

RE: Multiple forms, looping and inserting

Thanks to Matt and Philip for helping out with this. I have the form page displaying correctly now. HOWEVER, (and there always is one with me) I thought of one of those user-error things. What if the user tells the page she wants to add 10 records, but only fills in eight of them? If I use the

RE: Multiple forms, looping and inserting

Hmm...could just check if they are empty?? And only add to the database if they are not empty? So loop over the fields during the insert query, and only run the insert query if the field is NEQ . So even if they select 15 records and only actually fill out 5 you won't try to insert anything.

RE: Multiple forms, looping and inserting

Sounds like a plan, thanks Gel. I'll try it out when I get home :) okies?? ;) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 4/4/2003 8:25:30 AM

RE: Multiple forms, looping and inserting

Yesh! Okies! :) -Gel -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sounds like a plan, thanks Gel. I'll try it out when I get home :) okies?? ;) ~| Archives:

Re: Multiple forms, looping and inserting

I've got something like that. This isn't what you were describing, but you should be able to take this core and build what you describe from it without trouble. Basically what I do is output my variable block of form fields inside of a query loop (your example would use a simple index loop).