dynamic form values

[Dave Karmens]

If I have say 10 fixed variables, how can I set their values = to that
of a form that is built dynamically?

column1 column2
email = formvalue(0)
fname = formvalue(1)
lname = formvalue(2)

etc..

lastvar = formvalue(9)

[Ray at]

Re: dynamic form values

What do you mean? <input type="text" value="<%=varia bleName%>">

Ray at work

"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
news:%23MaQ2JL$ DHA.2348@TK2MSF TNGP09.phx.gbl. ..[color=blue]
> If I have say 10 fixed variables, how can I set their values = to that
> of a form that is built dynamically?
>
> column1 column2
> email = formvalue(0)
> fname = formvalue(1)
> lname = formvalue(2)
>
> etc..
>
> lastvar = formvalue(9)[/color]

[Dave Karmens]

Re: dynamic form values

No, I would need to loop though the values of a drop down list and
assign value1 to email, value2 to fname...

Ray at <%=sLocation% > [MVP] wrote:
[color=blue]
> What do you mean? <input type="text" value="<%=varia bleName%>">
>
> Ray at work
>
> "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> news:%23MaQ2JL$ DHA.2348@TK2MSF TNGP09.phx.gbl. ..
>[color=green]
>>If I have say 10 fixed variables, how can I set their values = to that
>>of a form that is built dynamically?
>>
>>column1 column2
>>email = formvalue(0)
>>fname = formvalue(1)
>>lname = formvalue(2)
>>
>>etc..
>>
>>lastvar = formvalue(9)[/color]
>
>
>[/color]

[Ray at]

Re: dynamic form values

When, when the page is submitted? When it is loaded? Can you explain this
in a little more detail?

Ray at work

"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
news:%23FJWoTL$ DHA.3816@TK2MSF TNGP09.phx.gbl. ..[color=blue]
> No, I would need to loop though the values of a drop down list and
> assign value1 to email, value2 to fname...
>
> Ray at <%=sLocation% > [MVP] wrote:
>[color=green]
> > What do you mean? <input type="text" value="<%=varia bleName%>">
> >
> > Ray at work
> >
> > "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> > news:%23MaQ2JL$ DHA.2348@TK2MSF TNGP09.phx.gbl. ..
> >[color=darkred]
> >>If I have say 10 fixed variables, how can I set their values = to that
> >>of a form that is built dynamically?
> >>
> >>column1 column2
> >>email = formvalue(0)
> >>fname = formvalue(1)
> >>lname = formvalue(2)
> >>
> >>etc..
> >>
> >>lastvar = formvalue(9)[/color]
> >
> >
> >[/color][/color]

[Adrian Forbes [ASP MVP]]

Re: dynamic form values

> No, I would need to loop though the values of a drop down list and[color=blue]
> assign value1 to email, value2 to fname...[/color]

When you have a drop-down box only the selected item is submitted with the
form, the non-selected values are "lost"

[Dave Karmens]

Re: dynamic form values

A user will fill out the dropdown list and hit submit - a form will then
map the constants to the form values to build a SQL string that will
be passed to a stored procedure.

Ray at <%=sLocation% > [MVP] wrote:
[color=blue]
> When, when the page is submitted? When it is loaded? Can you explain this
> in a little more detail?
>
> Ray at work
>
> "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> news:%23FJWoTL$ DHA.3816@TK2MSF TNGP09.phx.gbl. ..
>[color=green]
>>No, I would need to loop though the values of a drop down list and
>>assign value1 to email, value2 to fname...
>>
>>Ray at <%=sLocation% > [MVP] wrote:
>>
>>[color=darkred]
>>>What do you mean? <input type="text" value="<%=varia bleName%>">
>>>
>>>Ray at work
>>>
>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
>>>news:%23MaQ2 JL$DHA.2348@TK2 MSFTNGP09.phx.g bl...
>>>
>>>
>>>>If I have say 10 fixed variables, how can I set their values = to that
>>>>of a form that is built dynamically?
>>>>
>>>>column1 column2
>>>>email = formvalue(0)
>>>>fname = formvalue(1)
>>>>lname = formvalue(2)
>>>>
>>>>etc..
>>>>
>>>>lastvar = formvalue(9)
>>>
>>>
>>>[/color][/color]
>
>[/color]

[Dave Karmens]

Re: dynamic form values

Yes, I don't want the non-selected values.

The form is built dynamically from an uploaded .csv -- the first line of
the .csv is loaded into a drop down list. There is another, static list
that matches up with those values.

Adrian Forbes [ASP MVP] wrote:
[color=blue][color=green]
>>No, I would need to loop though the values of a drop down list and
>>assign value1 to email, value2 to fname...[/color]
>
>
> When you have a drop-down box only the selected item is submitted with the
> form, the non-selected values are "lost"
>
>[/color]

[Ray at]

Re: dynamic form values

So, you'll have an unknown number of values to assign to an unknown number
of variables? What about putting them in an array? If I fill out your
form, and I enter these terms in your select box:

cat
bird
ferret

what is the ultimate goal as far as what your SQL string will look like?

Ray at home

"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
news:eqMXBmL$DH A.2348@TK2MSFTN GP09.phx.gbl...[color=blue]
> A user will fill out the dropdown list and hit submit - a form will then
> map the constants to the form values to build a SQL string that will
> be passed to a stored procedure.
>
> Ray at <%=sLocation% > [MVP] wrote:
>[color=green]
> > When, when the page is submitted? When it is loaded? Can you explain[/color][/color]
this[color=blue][color=green]
> > in a little more detail?
> >
> > Ray at work
> >
> > "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> > news:%23FJWoTL$ DHA.3816@TK2MSF TNGP09.phx.gbl. ..
> >[color=darkred]
> >>No, I would need to loop though the values of a drop down list and
> >>assign value1 to email, value2 to fname...
> >>
> >>Ray at <%=sLocation% > [MVP] wrote:
> >>
> >>
> >>>What do you mean? <input type="text" value="<%=varia bleName%>">
> >>>
> >>>Ray at work
> >>>
> >>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> >>>news:%23MaQ2 JL$DHA.2348@TK2 MSFTNGP09.phx.g bl...
> >>>
> >>>
> >>>>If I have say 10 fixed variables, how can I set their values = to that
> >>>>of a form that is built dynamically?
> >>>>
> >>>>column1 column2
> >>>>email = formvalue(0)
> >>>>fname = formvalue(1)
> >>>>lname = formvalue(2)
> >>>>
> >>>>etc..
> >>>>
> >>>>lastvar = formvalue(9)
> >>>
> >>>
> >>>[/color]
> >
> >[/color][/color]

[Dave Karmens]

Re: dynamic form values

Hey Ray, thanks for sticking in...

I'll have an unknown number of values loaded from the .CSV, but no more
than 10. There will also be a fixed number of variables to assign them
to. If there is only 7 loaded the rest will be set to "".

The .csv might have user user_email, first_name, last_name so they would
map those to the fixed values email, fname, lname.

The SQL string is a very simple insert:

insert into tbl_test (email, fname, lname)
values ('"&user_email& "','"&first_nam e&"','"&last_na me&"')


This is the basic idea:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitl ed Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="300">
<tr>
<td>Fixed List</td>
<td>CSV List</td>
</tr>
<tr>
<td>Email</td>
<td><select name="flds">
<option name="none" value="none">no ne</option>
<option name="user_emai l" value="user_ema il">user_emai l</option>
<option name="user_fnam e" value="user_fna me">user_fnam e</option>
<option name="user_lnam e" value="user_lna me">user_lnam e</option>
</select></td>
</tr>
<tr>
<td>First Name</td>
<td><select name="flds">
<option name="none" value="none">no ne</option>
<option name="user_emai l" value="user_ema il">user_emai l</option>
<option name="user_fnam e" value="user_fna me">user_fnam e</option>
<option name="user_lnam e" value="user_lna me">user_lnam e</option>
</select></td>
</tr>
<tr>
<td>Last Name</td>
<td><select name="flds">
<option name="none" value="none">no ne</option>
<option name="user_emai l" value="user_ema il">user_emai l</option>
<option name="user_fnam e" value="user_fna me">user_fnam e</option>
<option name="user_lnam e" value="user_lna me">user_lnam e</option>
</select></td>
</tr>
</table>
</body>
</html>

Ray at <%=sLocation% > [MVP] wrote:[color=blue]
> So, you'll have an unknown number of values to assign to an unknown number
> of variables? What about putting them in an array? If I fill out your
> form, and I enter these terms in your select box:
>
> cat
> bird
> ferret
>
> what is the ultimate goal as far as what your SQL string will look like?
>
> Ray at home
>
> "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> news:eqMXBmL$DH A.2348@TK2MSFTN GP09.phx.gbl...
>[color=green]
>>A user will fill out the dropdown list and hit submit - a form will then
>> map the constants to the form values to build a SQL string that will
>>be passed to a stored procedure.
>>
>>Ray at <%=sLocation% > [MVP] wrote:
>>
>>[color=darkred]
>>>When, when the page is submitted? When it is loaded? Can you explain[/color][/color]
>
> this
>[color=green][color=darkred]
>>>in a little more detail?
>>>
>>>Ray at work
>>>
>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
>>>news:%23FJWo TL$DHA.3816@TK2 MSFTNGP09.phx.g bl...
>>>
>>>
>>>>No, I would need to loop though the values of a drop down list and
>>>>assign value1 to email, value2 to fname...
>>>>
>>>>Ray at <%=sLocation% > [MVP] wrote:
>>>>
>>>>
>>>>
>>>>>What do you mean? <input type="text" value="<%=varia bleName%>">
>>>>>
>>>>>Ray at work
>>>>>
>>>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
>>>>>news:%23Ma Q2JL$DHA.2348@T K2MSFTNGP09.phx .gbl...
>>>>>
>>>>>
>>>>>
>>>>>>If I have say 10 fixed variables, how can I set their values = to that
>>>>>>of a form that is built dynamically?
>>>>>>
>>>>>>column1 column2
>>>>>>email = formvalue(0)
>>>>>>fname = formvalue(1)
>>>>>>lname = formvalue(2)
>>>>>>
>>>>>>etc..
>>>>>>
>>>>>>lastvar = formvalue(9)
>>>>>
>>>>>
>>>>>
>>>[/color][/color]
>
>[/color]

[Ray at]

Re: dynamic form values

In that case, split your select value and assign the values to your
variables, like:

On Error Resume Next
firstvar = Request.Form("s elect")(1)
secondvar = Request.Form("s elect")(2)
thirdvar = Request.Form("s elect")(3)
fourthvar = Request.Form("s elect")(4)
fifthvar = Request.Form("s elect")(5)
sixthvar = Request.Form("s elect")(6)
seventhvar = Request.Form("s elect")(7)
eighthvar = Request.Form("s elect")(8)
ninthvar = Request.Form("s elect")(9)
tenthvar = Request.Form("s elect")(10)
On Error Goto 0

Ray at work




"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
news:Oze$HtT$DH A.2040@TK2MSFTN GP12.phx.gbl...[color=blue]
> Hey Ray, thanks for sticking in...
>
> I'll have an unknown number of values loaded from the .CSV, but no more
> than 10. There will also be a fixed number of variables to assign them
> to. If there is only 7 loaded the rest will be set to "".
>
> The .csv might have user user_email, first_name, last_name so they would
> map those to the fixed values email, fname, lname.
>
> The SQL string is a very simple insert:
>
> insert into tbl_test (email, fname, lname)
> values ('"&user_email& "','"&first_nam e&"','"&last_na me&"')
>
>
> This is the basic idea:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd">
> <html>
> <head>
> <title>Untitl ed Document</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> </head>
> <body>
> <table width="300">
> <tr>
> <td>Fixed List</td>
> <td>CSV List</td>
> </tr>
> <tr>
> <td>Email</td>
> <td><select name="flds">
> <option name="none" value="none">no ne</option>
> <option name="user_emai l" value="user_ema il">user_emai l</option>
> <option name="user_fnam e" value="user_fna me">user_fnam e</option>
> <option name="user_lnam e" value="user_lna me">user_lnam e</option>
> </select></td>
> </tr>
> <tr>
> <td>First Name</td>
> <td><select name="flds">
> <option name="none" value="none">no ne</option>
> <option name="user_emai l" value="user_ema il">user_emai l</option>
> <option name="user_fnam e" value="user_fna me">user_fnam e</option>
> <option name="user_lnam e" value="user_lna me">user_lnam e</option>
> </select></td>
> </tr>
> <tr>
> <td>Last Name</td>
> <td><select name="flds">
> <option name="none" value="none">no ne</option>
> <option name="user_emai l" value="user_ema il">user_emai l</option>
> <option name="user_fnam e" value="user_fna me">user_fnam e</option>
> <option name="user_lnam e" value="user_lna me">user_lnam e</option>
> </select></td>
> </tr>
> </table>
> </body>
> </html>
>
> Ray at <%=sLocation% > [MVP] wrote:[color=green]
> > So, you'll have an unknown number of values to assign to an unknown[/color][/color]
number[color=blue][color=green]
> > of variables? What about putting them in an array? If I fill out your
> > form, and I enter these terms in your select box:
> >
> > cat
> > bird
> > ferret
> >
> > what is the ultimate goal as far as what your SQL string will look like?
> >
> > Ray at home
> >
> > "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> > news:eqMXBmL$DH A.2348@TK2MSFTN GP09.phx.gbl...
> >[color=darkred]
> >>A user will fill out the dropdown list and hit submit - a form will then
> >> map the constants to the form values to build a SQL string that will
> >>be passed to a stored procedure.
> >>
> >>Ray at <%=sLocation% > [MVP] wrote:
> >>
> >>
> >>>When, when the page is submitted? When it is loaded? Can you explain[/color]
> >
> > this
> >[color=darkred]
> >>>in a little more detail?
> >>>
> >>>Ray at work
> >>>
> >>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> >>>news:%23FJWo TL$DHA.3816@TK2 MSFTNGP09.phx.g bl...
> >>>
> >>>
> >>>>No, I would need to loop though the values of a drop down list and
> >>>>assign value1 to email, value2 to fname...
> >>>>
> >>>>Ray at <%=sLocation% > [MVP] wrote:
> >>>>
> >>>>
> >>>>
> >>>>>What do you mean? <input type="text" value="<%=varia bleName%>">
> >>>>>
> >>>>>Ray at work
> >>>>>
> >>>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> >>>>>news:%23Ma Q2JL$DHA.2348@T K2MSFTNGP09.phx .gbl...
> >>>>>
> >>>>>
> >>>>>
> >>>>>>If I have say 10 fixed variables, how can I set their values = to[/color][/color][/color]
that[color=blue][color=green][color=darkred]
> >>>>>>of a form that is built dynamically?
> >>>>>>
> >>>>>>column1 column2
> >>>>>>email = formvalue(0)
> >>>>>>fname = formvalue(1)
> >>>>>>lname = formvalue(2)
> >>>>>>
> >>>>>>etc..
> >>>>>>
> >>>>>>lastvar = formvalue(9)
> >>>>>
> >>>>>
> >>>>>
> >>>[/color]
> >
> >[/color][/color]

[Dave Karmens]

Re: dynamic form values

Aaaah that looks like it will do! Thanks Ray!


Ray at <%=sLocation% > [MVP] wrote:
[color=blue]
> In that case, split your select value and assign the values to your
> variables, like:
>
> On Error Resume Next
> firstvar = Request.Form("s elect")(1)
> secondvar = Request.Form("s elect")(2)
> thirdvar = Request.Form("s elect")(3)
> fourthvar = Request.Form("s elect")(4)
> fifthvar = Request.Form("s elect")(5)
> sixthvar = Request.Form("s elect")(6)
> seventhvar = Request.Form("s elect")(7)
> eighthvar = Request.Form("s elect")(8)
> ninthvar = Request.Form("s elect")(9)
> tenthvar = Request.Form("s elect")(10)
> On Error Goto 0
>
> Ray at work
>
>
>
>
> "Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
> news:Oze$HtT$DH A.2040@TK2MSFTN GP12.phx.gbl...
>[color=green]
>>Hey Ray, thanks for sticking in...
>>
>>I'll have an unknown number of values loaded from the .CSV, but no more
>>than 10. There will also be a fixed number of variables to assign them
>>to. If there is only 7 loaded the rest will be set to "".
>>
>>The .csv might have user user_email, first_name, last_name so they would
>>map those to the fixed values email, fname, lname.
>>
>>The SQL string is a very simple insert:
>>
>>insert into tbl_test (email, fname, lname)
>>values ('"&user_email& "','"&first_nam e&"','"&last_na me&"')
>>
>>
>>This is the basic idea:
>>
>><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
>>"http://www.w3.org/TR/html4/loose.dtd">
>><html>
>><head>
>><title>Untitl ed Document</title>
>><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
>></head>
>><body>
>><table width="300">
>> <tr>
>> <td>Fixed List</td>
>> <td>CSV List</td>
>> </tr>
>> <tr>
>> <td>Email</td>
>> <td><select name="flds">
>> <option name="none" value="none">no ne</option>
>> <option name="user_emai l" value="user_ema il">user_emai l</option>
>> <option name="user_fnam e" value="user_fna me">user_fnam e</option>
>> <option name="user_lnam e" value="user_lna me">user_lnam e</option>
>> </select></td>
>> </tr>
>> <tr>
>> <td>First Name</td>
>> <td><select name="flds">
>> <option name="none" value="none">no ne</option>
>> <option name="user_emai l" value="user_ema il">user_emai l</option>
>> <option name="user_fnam e" value="user_fna me">user_fnam e</option>
>> <option name="user_lnam e" value="user_lna me">user_lnam e</option>
>> </select></td>
>> </tr>
>> <tr>
>> <td>Last Name</td>
>> <td><select name="flds">
>> <option name="none" value="none">no ne</option>
>> <option name="user_emai l" value="user_ema il">user_emai l</option>
>> <option name="user_fnam e" value="user_fna me">user_fnam e</option>
>> <option name="user_lnam e" value="user_lna me">user_lnam e</option>
>> </select></td>
>> </tr>
>></table>
>></body>
>></html>
>>
>>Ray at <%=sLocation% > [MVP] wrote:
>>[color=darkred]
>>>So, you'll have an unknown number of values to assign to an unknown[/color][/color]
>
> number
>[color=green][color=darkred]
>>>of variables? What about putting them in an array? If I fill out your
>>>form, and I enter these terms in your select box:
>>>
>>>cat
>>>bird
>>>ferret
>>>
>>>what is the ultimate goal as far as what your SQL string will look like?
>>>
>>>Ray at home
>>>
>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
>>>news:eqMXBmL $DHA.2348@TK2MS FTNGP09.phx.gbl ...
>>>
>>>
>>>>A user will fill out the dropdown list and hit submit - a form will then
>>>> map the constants to the form values to build a SQL string that will
>>>>be passed to a stored procedure.
>>>>
>>>>Ray at <%=sLocation% > [MVP] wrote:
>>>>
>>>>
>>>>
>>>>>When, when the page is submitted? When it is loaded? Can you explain
>>>
>>>this
>>>
>>>
>>>>>in a little more detail?
>>>>>
>>>>>Ray at work
>>>>>
>>>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
>>>>>news:%23FJ WoTL$DHA.3816@T K2MSFTNGP09.phx .gbl...
>>>>>
>>>>>
>>>>>
>>>>>>No, I would need to loop though the values of a drop down list and
>>>>>>assign value1 to email, value2 to fname...
>>>>>>
>>>>>>Ray at <%=sLocation% > [MVP] wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>What do you mean? <input type="text" value="<%=varia bleName%>">
>>>>>>>
>>>>>>>Ray at work
>>>>>>>
>>>>>>>"Dave Karmens" <spam_just1code r@yahoo.ca> wrote in message
>>>>>>>news:%23 MaQ2JL$DHA.2348 @TK2MSFTNGP09.p hx.gbl...
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>If I have say 10 fixed variables, how can I set their values = to[/color][/color]
>
> that
>[color=green][color=darkred]
>>>>>>>>of a form that is built dynamically?
>>>>>>>>
>>>>>>>>colum n1 column2
>>>>>>>>email = formvalue(0)
>>>>>>>>fname = formvalue(1)
>>>>>>>>lname = formvalue(2)
>>>>>>>>
>>>>>>>>etc..
>>>>>>>>
>>>>>>>>lastv ar = formvalue(9)
>>>>>>>
>>>>>>>
>>>>>>>
>>>[/color][/color]
>
>[/color]