How to determine multi records entered on the web form

[Jean]

Hello,

I have a classical ASP web data entry form with 20 rows that allows users to
enter multiple records at once, my questions are:

a.. How do you determine the number of rows entered by a user on the web
form?
b.. How do you save multi records to database?
Please assist me.


Thanks!!!



Jean

[Mohamed Hosam]

Try this:

MRField = Request.Form("Field_Name")

If MRField <> "" then
' Open a DB Connection here

GetRecords = Split(MRField, Chr(13))
For i = 0 to UBound(GetRecords)
Query = "Insert Into DB(DBField) Values('" & GetRecords(i) & "')"
Conn.Execute Query
next

' Close Connection here

End If


Mohamed

"Jean" <jeanwang@email.arizona.edu> wrote in message
news:#GSunw#mDHA.1676@TK2MSFTNGP09.phx.gbl...

> Hello,
>
> I have a classical ASP web data entry form with 20 rows that allows users

to

> enter multiple records at once, my questions are:
>
> a.. How do you determine the number of rows entered by a user on the web
> form?
> b.. How do you save multi records to database?
> Please assist me.
>
>
> Thanks!!!
>
>
>
> Jean
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003

[Jean]

Thank you very much! I will apply this to my web form. Do you think the
performance will be better if I use a stored procedure to insert each record
(my web form provides up to 95 empty rows)?

Another thing I was thinking about; is it possible to program the empty rows
on the form as needed by a user? A new empty row would be displayed, if a
user pressed [enter] key.



Thanks again.



Jean



"Mohamed Hosam" <info@internetplus.biz> wrote in message
news:uxNyhfAnDHA.3612@TK2MSFTNGP11.phx.gbl...

> Try this:
>
> MRField = Request.Form("Field_Name")
>
> If MRField <> "" then
> ' Open a DB Connection here
>
> GetRecords = Split(MRField, Chr(13))
> For i = 0 to UBound(GetRecords)
> Query = "Insert Into DB(DBField) Values('" & GetRecords(i) & "')"
> Conn.Execute Query
> next
>
> ' Close Connection here
>
> End If
>
>
> Mohamed
>
> "Jean" <jeanwang@email.arizona.edu> wrote in message
> news:#GSunw#mDHA.1676@TK2MSFTNGP09.phx.gbl...

> > Hello,
> >
> > I have a classical ASP web data entry form with 20 rows that allows

users

> to

> > enter multiple records at once, my questions are:
> >
> > a.. How do you determine the number of rows entered by a user on the

web

> > form?
> > b.. How do you save multi records to database?
> > Please assist me.
> >
> >
> > Thanks!!!
> >
> >
> >
> > Jean
> >
> >

>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
>
>