Home > ASP Development > Selecting dropdown

Selecting dropdown

Hi sorry had to start another thread juast to kill this issue. The way I have the code now, the 2nd dropdown is listing all of the values in the table. I am trying to get it to filter by the alphabetical letter selected in the 1st drop down. Right now it is just listing all of the values. Anyone able to figure that out?

Code:

<table>

	<td style="WIDTH: 577px; HEIGHT: 26px" colspan="5" valign="top">

		<p class="mainlink">Source Code:<br>



				<select name="dropdownone" size="1">

				<option selected></option>

				<option value="A">A</option>

				<option value="B">B</option>

				<option value="C">C</option>

				<option value="D">D</option>

				<option value="E">E</option>

				<option value="F">E</option>

				<option value="G">G</option>

				<option value="H">H</option>

				<option value="I">I</option>

				<option value="J">J</option>

				<option value="K">K</option>

				<option value="L">L</option>

				<option value="M">M</option>

				<option value="N">N</option>

				<option value="O">O</option>

				<option value="P">P</option>

				<option value="Q">Q</option>

				<option value="R">R</option>

				<option value="S">S</option>

				<option value="T">T</option>

				<option value="U">U</option>

				<option value="V">V</option>

				<option value="W">W</option>

				<option value="X">X</option>

				<option value="Y">Y</option>

				<option value="Z">Z</option>

			</select><br>

			

				 

<%

				Set cst = Server.CreateObject ("ADODB.Connection")

				Set objRS = Server.CreateObject ("ADODB.Recordset")

				DBpath = server.MapPath("southerncatholic_1.mdb")

				strCnn = "provider=microsoft.jet.oledb.4.0; data source=" & Server.MapPath("../database/southerncatholic_1.mdb")

				

				cst.Open strCnn

				

				objRS.Open "SELECT * FROM hscodes WHERE institution_name LIKE '"& dropdownone&"%'",cst

																	

				If Not objRS.EOF Then

				

				objRS.MoveFirst



				%>

			

				<select class="mainlinkblack" name="sourcecode" tabindex="20">

				<option></option>

				

				<%

				

				Do While Not objRS.EOF

				%>

				<option value="<%= objRS.Fields("institution_code")%>">"<%= objRS.Fields("institution_name")%></option>

				

				<%

				objRS.MoveNext

				Loop

				%>

			</select>

																		

				<%

				End If

				objRS.Close

				Set objRS =  Nothing

				cst.Close

				Set objDC = Nothing

				%></p>

	</td>

</table>

Guest

Correct me if I'm wrong, but you need to post the result of the form and then use the value to get the data. Have you tried Response.Write on the SQL string to determine if its correct? Try placing a submit button, and then checking with a if Request.Form("button") <> "" then [insert the RS access here]

Was this answer helpful ? Yes No

Guest

See this for information on how to achieve what you are after:

http://forums.aspfree.com/t53159/s.html

Was this answer helpful ? Yes No

Guest

try something like

Code:



<form name="form" method="post">

<table>

	<td style="WIDTH: 577px; HEIGHT: 26px" colspan="5" valign="top">

		<p class="mainlink">Source Code:<br>



				<select name="dropdownone" size="1">

				<option selected></option>

				<option value="A">A</option>

				<option value="B">B</option>

				<option value="C">C</option>

				<option value="D">D</option>

				<option value="E">E</option>

				<option value="F">E</option>

				<option value="G">G</option>

				<option value="H">H</option>

				<option value="I">I</option>

				<option value="J">J</option>

				<option value="K">K</option>

				<option value="L">L</option>

				<option value="M">M</option>

				<option value="N">N</option>

				<option value="O">O</option>

				<option value="P">P</option>

				<option value="Q">Q</option>

				<option value="R">R</option>

				<option value="S">S</option>

				<option value="T">T</option>

				<option value="U">U</option>

				<option value="V">V</option>

				<option value="W">W</option>

				<option value="X">X</option>

				<option value="Y">Y</option>

				<option value="Z">Z</option>

			</select><br>

<input type="submit" name="button" value="submit">

</form>

then at the beginning of your code you have to have

Code:



if Request.Form("button")<>""

'its been submitted

'insert recordset access here

for your SQL string it should be

Code:



"SELECT * FROM hscodes WHERE institution_name LIKE '"& Request.Form("dropdownone")&"%'",cst

Was this answer helpful ? Yes No

Guest

Quote:

Originally Posted by PhattieM

try something like

Code:



<form name="form" method="post">

<table>

	<td style="WIDTH: 577px; HEIGHT: 26px" colspan="5" valign="top">

		<p class="mainlink">Source Code:<br>



				<select name="dropdownone" size="1">

				<option selected></option>

				<option value="A">A</option>

				<option value="B">B</option>

				<option value="C">C</option>

				<option value="D">D</option>

				<option value="E">E</option>

				<option value="F">E</option>

				<option value="G">G</option>

				<option value="H">H</option>

				<option value="I">I</option>

				<option value="J">J</option>

				<option value="K">K</option>

				<option value="L">L</option>

				<option value="M">M</option>

				<option value="N">N</option>

				<option value="O">O</option>

				<option value="P">P</option>

				<option value="Q">Q</option>

				<option value="R">R</option>

				<option value="S">S</option>

				<option value="T">T</option>

				<option value="U">U</option>

				<option value="V">V</option>

				<option value="W">W</option>

				<option value="X">X</option>

				<option value="Y">Y</option>

				<option value="Z">Z</option>

			</select><br>

<input type="submit" name="button" value="submit">

</form>

then at the beginning of your code you have to have

Code:



if Request.Form("button")<>""

'its been submitted

'insert recordset access here

for your SQL string it should be

Code:



"SELECT * FROM hscodes WHERE institution_name LIKE '"& Request.Form("dropdownone")&"%'",cst

Ohh, that was it, I actually had made everything just like you said before i saw that last post. What I was forgetting was the request form in the SQL statement. If I could add a thousand to your rep I would. Thanks a bunch, learned a lot there.

Was this answer helpful ? Yes No

Guest

Answer it

Ask Question About ASP Development

Selecting dropdown

Programming

Related Pages