467,207 Members | 1,288 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,207 developers. It's quick & easy.

dynamic form values

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)
Jul 19 '05 #1
  • viewed: 1890
Share:
10 Replies
What do you mean? <input type="text" value="<%=variableName%>">

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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)

Jul 19 '05 #2
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="<%=variableName%>">

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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)


Jul 19 '05 #3
When, when the page is submitted? When it is loaded? Can you explain this
in a little more detail?

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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="<%=variableName%>">

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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)


Jul 19 '05 #4
> No, I would need to loop though the values of a drop down list and
assign value1 to email, value2 to fname...


When you have a drop-down box only the selected item is submitted with the
form, the non-selected values are "lost"
Jul 19 '05 #5
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" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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="<%=variableName%>">

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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)


Jul 19 '05 #6
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:
No, I would need to loop though the values of a drop down list and
assign value1 to email, value2 to fname...

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

Jul 19 '05 #7
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" <sp*************@yahoo.ca> wrote in message
news:eq**************@TK2MSFTNGP09.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" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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="<%=variableName%>">

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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)


Jul 19 '05 #8
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_name&"','"&last_name&"' )
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>Untitled 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">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>First Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>Last Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
</table>
</body>
</html>

Ray at <%=sLocation%> [MVP] wrote:
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" <sp*************@yahoo.ca> wrote in message
news:eq**************@TK2MSFTNGP09.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" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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="<%=variableName%>">
>
>Ray at work
>
>"Dave Karmens" <sp*************@yahoo.ca> wrote in message
>news:%2****************@TK2MSFTNGP09.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)
>
>
>


Jul 19 '05 #9
In that case, split your select value and assign the values to your
variables, like:

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

Ray at work


"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:Oz**************@TK2MSFTNGP12.phx.gbl...
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_name&"','"&last_name&"' )
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>Untitled 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">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>First Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>Last Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
</table>
</body>
</html>

Ray at <%=sLocation%> [MVP] wrote:
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" <sp*************@yahoo.ca> wrote in message
news:eq**************@TK2MSFTNGP09.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" <sp*************@yahoo.ca> wrote in message
news:%2****************@TK2MSFTNGP09.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="<%=variableName%>">
>>
>>Ray at work
>>
>>"Dave Karmens" <sp*************@yahoo.ca> wrote in message
>>news:%2****************@TK2MSFTNGP09.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)
>>
>>
>>


Jul 19 '05 #10
Aaaah that looks like it will do! Thanks Ray!
Ray at <%=sLocation%> [MVP] wrote:
In that case, split your select value and assign the values to your
variables, like:

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

Ray at work


"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:Oz**************@TK2MSFTNGP12.phx.gbl...
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_name&"','"&last_name&"' )
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>Untitled 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">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>First Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
<tr>
<td>Last Name</td>
<td><select name="flds">
<option name="none" value="none">none</option>
<option name="user_email" value="user_email">user_email</option>
<option name="user_fname" value="user_fname">user_fname</option>
<option name="user_lname" value="user_lname">user_lname</option>
</select></td>
</tr>
</table>
</body>
</html>

Ray at <%=sLocation%> [MVP] wrote:
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" <sp*************@yahoo.ca> wrote in message
news:eq**************@TK2MSFTNGP09.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" <sp*************@yahoo.ca> wrote in message
>news:%2****************@TK2MSFTNGP09.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="<%=variableName%>">
>>>
>>>Ray at work
>>>
>>>"Dave Karmens" <sp*************@yahoo.ca> wrote in message
>>>news:%2****************@TK2MSFTNGP09.phx.gb l...
>>>
>>>
>>>
>>>
>>>>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)
>>>
>>>
>>>


Jul 19 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by deejayquai@gmail.com | last post: by
4 posts views Thread by =?Utf-8?B?RHlsYW5TbWl0aA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.