- Home
- Web Development
- Web Languages/Standards
- ASP
- Dynamic List boxes
Advertisement
| Hall of Fame |
- 1. neeraj52375,510
- 2. rdivilbiss69,262
- 3. sybe57,601
- 4. mgfranz57,490
- 5. hielo49,000
- 6. R_Harrison47,046
- 7. HainKurt39,300
- 8. leakim97125,400
- 9. mplungjan22,500
- 10. carrzkiss22,332
- 11. samic40021,784
- 12. angelIII20,950
- 13. octavient16,500
- 14. acperkins15,774
- 15. pradyahuja15,668
- 16. tobzzz14,286
- 17. theremon14,150
- 18. crshekharam14,082
- 19. guru_sami13,668
- 20. RobSamp...13,100
- 21. Springy55512,600
- 22. strickdd12,064
- 23. carl_tawn11,500
- 24. golfDoctor11,300
- 25. _Stilgar_11,000
- 25. reza_rad11,000
- 1. fritz_the...3,975,430
- 2. alorentz1,929,293
- 3. amit_g1,340,338
- 4. hielo1,303,753
- 5. b0lsc0tt954,747
- 6. sybe951,853
- 7. kevp75933,413
- 8. angelIII931,245
- 9. hongjun922,466
- 10. ap_sajith921,034
- 11. WMIF899,748
- 12. carrzkiss811,769
- 13. jitganguly786,812
- 14. acperkins739,974
- 15. neeraj523715,714
- 16. ryancys689,299
- 17. peh803684,060
- 18. Silvers5625,555
- 19. carl_tawn614,210
- 20. GaryC123576,347
- 21. golfDoctor535,413
- 22. apresto525,417
- 23. SquareHead517,787
- 24. mgfranz479,110
- 25. deighc466,721
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Dynamic List boxes
Asked by Kevin_S in Active Server Pages (ASP)
Tags: drop, list
First - I know this has been answered a billion times on this site and I've read some of the posts but unfortunitely my current working knowledge of ASP classic is limited as I've just moved over from client/server to web development so some of the posts I have been trying to interpret on this subject are so complex its not making sense to me so I thought I would start my own post and hope someone is willing to help out.
Basically, I want to create an example that I can learn from and adapt for future uses. I want to be able to select an item in one list box and have that then update/change the list of available items in the second list box. for this simple example I have created 2 tables in sql server with the following properties:
table: test_productmain
PK: ProductID
field: ProductName
table: test_productsub
PK: ProDetailID
FK: ProductID
field: ProDetailName
these two tables are joined 1-many on ProductID... Simple enough. Now I have created a select box that queries the table: test_productmain, loops the recordset and populated the drop down fields. Here is the code I am using:
CODE.................
<html>
<head>
</head>
<body>
<form name="testlist" method="post" action="testlist.asp">
<select name="selectmain">
<%
connstr = "DRIVER=SQL Server;SERVER=Jerry;DATABA
sql = "Select ProductID, ProductName From dbo.test_productmain"
set conn = Server.CreateObject("ADODB
conn.Open connstr
set rs = Server.CreateObject("ADODB
rs.open sql,conn, 3
do until rs.eof
for j = 1 to rs.fields.count - 1
%>
<option value="<%= rs.fields("ProductID").val
<%
next
rs.movenext
loop
rs.close
conn.close
set rs = nothing
set conn = nothing
%>
</select>
</form>
</body>
</html>
CODE END.......................
This works great and populates the main list/select box. My question is then, based on what I have above - what are the next steps to create another listbox which will be able to retrieve the ProductID value from the main listbox and use that as part of the Where clause in the SQL...? I'm making this work 500 points as I am really appreciative to anyone who can set the rest of this up for me as I'm at a loss. Also - my javascript is even worse then my vbscript - note: this solution needs to me in vbscript for asp classic as this is not a .net app! and any javascript may need a little hand holding :)
If this were client/server I could crank this out in 3 seconds!!! so frustrated :)
Appreciate all help!
Kev
| [+][-]10/20/04 10:42 PM, ID: 12366764Accepted Solution |
Your question has an Asker Certified™ answer! Kevin_S verified that this solution worked for them--which means it will likely work for you, too. Click to view the solution free for 30-days now.
