Large insert string

4 Apr 2007 3:37 PM

David

Hi,

I have an asp page with a form, which has a lot of fields ........ 30
to 40 !

Is there an easier way to loop through all the fields submitted to the
insert page or is the only way to do it using the standard,
request.form for each field and then INSERT INTO Reports (ReportID,
ReceivedDa .................... very lengthy for this amount of
fields.

Perhaps there is a way of looping through some sort of collection ???

Thanks

David

4 Apr 2007 3:45 PM

Bob Barrows [MVP]

David wrote:
Show quoteHide quote

> Hi,
>
> I have an asp page with a form, which has a lot of fields ........ 30
> to 40 !
>
> Is there an easier way to loop through all the fields submitted to the
> insert page or is the only way to do it using the standard,
> request.form for each field and then INSERT INTO Reports (ReportID,
> ReceivedDa .................... very lengthy for this amount of
> fields.
>
> Perhaps there is a way of looping through some sort of collection ???
>
> Thanks
>

http://www.aspfaq.com/2036

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Thread options