|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
drop down list box |
|
From: |
suresh |
|
Date: |
2/24/2001 6:28:04 AM |
|
IP: |
203.199.228.246 |
Iam new to asp development. I have a problem in drop down list box. Iam using a vb component and
ms-access2000 to fetch the empnos into drop down list box. All the records ie (empno) gets
populated in drop down list box.
Iam successful in displaying a single records like firstname,lastname,type into the respective
input box ie(text boxes). If i have many empno into the drop down list, iam not able to display
its corressponding item selected. Do i have to write any function.
I have pasted my coding below for yr reference. If my coding is wrong pls let me know.
Kindly provide me an sample code to retrived records based on item selected from drop down list
box. Pls Help me...
I don't know where i have gone wrong in my coding.
I want to send the fetched records into another function called MyFunction() which takes some
parameters like date,no... etc.
Thanks in advance
Suresh
<Html>
<Body>
<Select Name="No">
<%
Dim objDC, objRS, objRsLoc
Dim Nos, Names
Set objDC=Server.CreateObject("ABC.MyClass") -'Calling my component
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRs=objDC.MyList 'Calling my function
Nos = Request("Empno")
If Not objRS.EOF Then
objRS.MoveFirst%>
<% Do while not objRs.EOF%>
<Option Value="<%=objRs("Empno") %>"><%=objRs("Empno") %> </Options>
<TABLE BORDER=1>
<TR>
<TD><B>Emp Number</B></TD>
<TD><B>First Name</B></TD>
<TD><B>Last |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
