|
| |
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
 |
Select problem - 3/31/2005 15:55:29
Hey, I have a problem with select command, I have a few selection command with id=1,id=2.....id=10
I would like to add those selection to a database but I can't because I don't know how to call those selection to the link for example <a href addto.asp?menu_id=" here suppose to be the name that I am sending to the other page but if I have few selection how do I do it? Can anyone help me.....?
while not rs5.EOF
tempname=""
meal=rs5("id_categ")
while not rs.EOF
if rs("id_categ")=meal then
tempname=rs("category")
end if
rs.MoveNext
wend
Response.Write "<tr><td>" & tempname & "</tr></td>"
rs.MoveFirst
Response.Write "<td>"
if tempname<>"" then
Response.Write "<SELECT id=select1 name=" & count & ">"
Response.Write "<option selected value=1>choose menu</option>"
while not rs.EOF
if rs("id_categ")=meal then
Response.Write "<option value=" & rs("id") & ">" & rs("food") & "</option>"
end if
rs.MoveNext
wend
Response.Write "</SELECT>"
end if
|
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Select problem - 3/31/2005 16:29:22
are you trying to pass a variable or are you trying to pass specefic data? is the data coming from a form? (sorry, I couldn't really understand by the code what you were trying to do with the lin)
by variable it is:
addto.asp?var="& var1 & var2 & var3
by form it is:
addto.asp?var="&Request.Form("var1")&Request.form("var2")
is that anything close what what you are asking or am I waaay off? :)
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: Select problem - 4/1/2005 3:09:58
What I did is I used the select command many time (like 8 times) so instead to write the select command 8 time I used this code. I understand what you were say about the var but how do I know the var name from the select ?
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: Select problem - 4/1/2005 9:21:02
sorry I didn't understand what you were saying
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Select problem - 4/1/2005 10:38:30
I think I'm following you...you have 8 select statements (or somewhere around that) and you would like to pass the values of those select statements to a next page via hyperlink...if that is the case, then you will have to define each variable within the select statement to pass...it is like this:
on a spooky diet, after all the 2nd include file (include1), you will place:
<%
var1=fp_field(fp_rs,"field1")
var2=fp_field(fp_rs,"field2")
var3=fp_field(fp_rs,"field3")
var4=fp_field(fp_rs,"field4")
%>
You will do that for each select statement for variables you would like to create; however, make sure no duplicate variable names are created (in the above, you would replace items in bold)
Then, in you hyperlink you would do:
<a href="link.asp?var="& var1 & var2 & var3 & var4
you would have to modify that to be specefic to your needs...is that what you are wishing to do?
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: Select problem - 4/1/2005 11:14:19
I don't know those command you talked about but let me explain to you again, you are right about the 8 (or more) select statment, but it is in a loop (look at the code above) , my question is if I am choosing from the drop down menu (the select option....) how do I keep the chosen item? I can't do something like :
var=select
so ow do I do it?
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Select problem - 4/1/2005 11:23:37
Are you trying to pass whatever is selected in the select drop down? if that is so, then you would request the select name...
link.asp?var="&request.form(&name&)
Since the name of your select is a variable, I think that is the right syntax...am I getting any closer to what you want? :)
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: Select problem - 4/1/2005 11:29:53
I think you got it I will try it please look for me if there are any problems, by the way one more thing, can I do loop from array to the follwing link:
addto.asp?var="& var(1) & var(2) & var(3)
can I do :
addto.asp?var="& for i=1 to 3
var(i)
next
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: Select problem - 4/1/2005 11:36:34
do i put it at the same page where the selections are?
and you just gave me one selection, you forgot that I have 8 more selection
link.asp?var="&request.form(&name&)
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Select problem - 4/1/2005 11:42:38
Are you passing the values of the array to another array or to a page to call the values in a select statement or something besides placing them into another array?
You generally have to say something=something on the link...so it would be something similar to:
addto.asp?var1="&myArray(1)&"&"&"var2="&myArray(2)&"&"&"var3="&myArray(3)
For a loop, you could do something like:
<%
for i=1 to 8
myArray(i)=var&i
link=link&"var"&i&"="&"""&myArray(i)&"&"&
next
%>
then, the link would be:
addto.asp?&link
thats not testd, but should give a general idea on how to do it
| |
|
|
|
wizard_oz
Posts: 140
Joined: 9/3/2004
From: Ga,USA
Status: offline
|
RE: Select problem - 4/2/2005 6:56:52
dim arrSend(10)
Response.Write "<a href=addtobasket.asp?arrSend(1)="&arrMeal(1)& "&" & "arrSend(2)="&arrMeal(2) & ">click</a>"
can you please try to make a look from the line at the code?
| |
|
|
|
yogaboy
Posts: 377
Joined: 5/22/2004
Status: offline
|
RE: Select problem - 4/2/2005 8:39:51
I just answered the othe question you've put up related to this, but having read this I suppose you can pretty much ignore that! :)
Forgive me for asking the obvious question, but if you have 8 select menus and you want to pass them over to the next page, wouldn't it be easier to use the POST method with a Submit button and Request.Form("arrSendwhatever") on the next page??
Iain
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Select problem - 4/4/2005 12:36:32
Response.Write "<a href=addtobasket.asp?arrSend(1)="&arrMeal(1)& "&" & "arrSend(2)="&arrMeal(2) & ">click</a>"
The bolded items need to be changed. Change them to something simple like arrSend1 and arrSend2...then, on your second page, you would have to call them like <%request.querystring("arrSend1)"%>
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 