SQL Help plz

Canada66_2002 · #1 (**permalink**) 01-15-04, 10:31

hi im currently making a web page and on it it loads up data from an access database into a dropdown menu so it loads up all the names and then i want to have it so when i click on the buttton that goes to the next page which i have i want the result of what the person selected from the dropdown i notice that it is displayed in the address bar but how can i retrieve that data?> and display it on the screen?

r123456 · #2 (**permalink**) 01-15-04, 10:40

ASP = request.QueryString("param name")

Canada66_2002 · #3 (**permalink**) 01-15-04, 10:43

ok thank you very much for your help just two small question what is the ASP there for what will that do and then for the parameter name would i just put down dropdown? cuz in my address bar its displayed dropdown = "name" so what would i put for a param

r123456 · #4 (**permalink**) 01-15-04, 10:48

...?dropdown=value1

<%
Dim str As String
str = request.QueryString("dropdown")
%>

Canada66_2002 · #5 (**permalink**) 01-15-04, 10:54

alright well i tried using your code and it didnt work heres the code that i use

<html>
<% Dim str As String %>
<% str = request.getString("dropdown") %>

(str)
str
</html>

and it gives me an error on line 2 it says expected end of statement what should i do

r123456 · #6 (**permalink**) 01-15-04, 11:22

The previous statements have been corrected.

Canada66_2002 · #7 (**permalink**) 01-15-04, 14:46

what do you mean that the previous lines have been correct? if they were correct then why did they not work??

Canada66_2002 · #8 (**permalink**) 01-15-04, 14:48

hey this is the error that i get:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/results.asp, line 2

Dim str As String
--------^

gyuan · #9 (**permalink**) 01-15-04, 14:52

Please post your code here.

Canada66_2002 · #10 (**permalink**) 01-15-04, 14:57

alright here is the code for my first page which is the dropdown menu:

<html>
<% SQL="SELECT * FROM People ORDER BY Name"

set conn = server.createobject("ADODB.Connection")

conn.open "Swimming"

set people=conn.execute(SQL)

%>

<form action="results.asp" method="get" name="form3">
<select name="dropdown">

<%= people(0)%><br> <%= people(1)%><br> <%=people(2)%> </p><br>

<% do while not people.eof %>

<option value="<%= people(1)%>"><%= people(1)%></option>

<%people.movenext

loop%>

<% people.close %>

</select>
<input type="Submit" value="It Works" align="MIDDLE"> </form>

</html>

then when they click on that button its gonna take them to the result page which is were i wanna display what they selected and the code for this page looks like this

<html>
<% Dim str As String %>
<% str = request.getString("dropdown") %>

(str)
str
</html>

but i get an error that looks like what i posted above can you help me?

gyuan · #11 (**permalink**) 01-15-04, 15:01

It should be

<% str = request.QueryString("dropdown") %>

Canada66_2002 · #12 (**permalink**) 01-15-04, 15:04

no im sorry i still get the:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/results.asp, line 2

Dim str As String
--------^
any idea why???