Capturing Form values into an Array

tp194 · September 8th, 2004, 10:08 PM

Hi, this is probably an easy question to answer, but I'm throughly confused by arrays.

I have a form that is capturing info for up to 5 different vendors. For each vendor, I'm asking for 4 pieces of info (vendor name, alt1, alt2, alt3).

In my database, each alt needs to get put into it's own row, i.e:
Record 1 = vendorName, alt1
Record 2 = vendorName, alt2
Record 3 = vendorName, alt3

I think the best way to caputre this info from the html form is to put the data into an array, but I'm not sure how...

Any suggestions would very much appreciated.

Thanks

Terry

Santhi · September 9th, 2004, 03:33 AM

Yes put the data into an array.You have five different vendors right and also u r asking for 4 different options,if it is fixed then create an two dimensional array of size [5][4].Loop through it and set the value(vendorName,alt1..)

sureshbabu · September 10th, 2004, 09:05 AM

Hi,
   If you look at the following code, you can get an idea...
--------------------------------
This is code for the 1st Page(Vendor.asp).
------------------------------
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<form name=fVendor method=post action="save.asp">
<%For i=1 To 5%>
    Author:<input type=text name=tVendor<%=i%>><br>
       alt1:<input type=text name=alt1<%=i%>><br>
       alt2:<input type=text name=alt2<%=i%>><br>
       alt3:<input type=text name=alt3<%=i%>><br><br>
<%Next%>
<input type=submit value=clickMe>
</form>

<P> </P>

</BODY>
</HTML>

-----------------------------------
This is the code for the 2nd page(save.asp)
----------------------------------

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
For i=1 to 5
    str1 = "tVendor" & i
    alt1 = "alt1" & i
    alt2 = "alt2" & i
    alt3 = "alt3" & i
    Response.Write Request.Form(str1) & "<br>"
    Response.Write Request.Form(alt1) & "<br>"
    Response.Write Request.Form(alt2) & "<br>"
    Response.Write Request.Form(alt3) & "<br>"
Next
%>

<P> </P>

</BODY>
</HTML>
--------------------------------------------

happygv · September 10th, 2004, 09:20 AM

Hi Terry,

Can you explain a bit about how it looks on your form and how you want that to be stored. I feel the sureshbabu's suggested code is not what Terry is looking for.

Cheers!

_________________________
- Vijay G
Strive for Perfection