Code Bank
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingCode Bank

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old March 3rd, 2004, 01:23 PM
kiteeShek kiteeShek is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 4 kiteeShek User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy drop down without submit button

I am fairly new to ASP and have never used javascript with it ...
Here's my problem.
I have a form with 2 drop down boxes among other stuff. The second dropdown box will populate depending upon the value selected in the first drop down. I need a way to submit the value selected in the first drop down; just as soon as it is selected or when the user moves to the next tab. It should not have a submit button.
(Once a value in the second drop down is selected, and the user clicks update, the control passes to another page.)

I tried using the onChange() for the <select>

<% DIM dept %>

That's the js code .. I'm pretty sure it's wrong
<SCRIPT LANGUAGE = "JavaScript">
//To get the building from the dropdown and display the appropriate rooms

function whichDepartment(department)
{
dept = department
return department
}

</SCRIPT>

<%

That's the drop down.
<select name="Dept" onChange="return whichDepartment(this)">
<%
strSQL = "SELECT * FROM Department " &_
"ORDER BY DepartmentName "
objRstAdd2.open strSQL, objConn

WHILE NOT objRstAdd2.EOF
%>
<option value="<%=objRstAdd2("DepartmentID")%>"><%=Mid(objRstAdd2("DepartmentName"), 1, 10)%></option>
<%
objRstAdd2.MoveNext
WEND
objRstAdd2.Close
%>
</select>

And thats the second drop down, which uses dept from the first drop down

<select name = "room">
<%

'dept = request("Dept")
strSQL = "SELECT Room FROM Room " &_
"WHERE Room.BuildingID IN (SELECT BuildingID FROM Building WHERE BuildingName = '"&authorizedBuilding&"') AND "&_
"Room.DepartmentID IN (SELECT DepartmentID FROM Department WHERE DepartmentName = '"& Dept &"') "&_
"ORDER BY Room "
objRstAdd2.open strSQL, objConn

WHILE NOT objRstAdd2.EOF
%>
<option value="<%=objRstAdd2("Room")%>"><%=(objRstAdd2("Room"))%></option>
<% objRstAdd2.MoveNext
WEND
objRstAdd2.Close
%>
</select>

Help!

Reply With Quote
  #2  
Old March 3rd, 2004, 02:29 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
 
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,760 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 5 h 22 m 16 sec
Reputation Power: 443
Please post you questions in the correct area of the forum. The code bank is for sample code only.

Reply With Quote
  #3  
Old March 3rd, 2004, 03:22 PM
kiteeShek kiteeShek is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 4 kiteeShek User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by Memnoch
Please post you questions in the correct area of the forum. The code bank is for sample code only.

My apologies. Won't happen again.

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingCode Bank > drop down without submit button


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway