Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding db values in a listbox

Status
Not open for further replies.

Trillithium

Technical User
Dec 9, 2000
27
0
0
NL
Please Help me. Im trying to add some of my access DB values in a listbox. All I get is an empty box with no errors. This is the partial script i'm writing. Where do i go wrong.

<form name=&quot;form2&quot; method=&quot;post&quot; action=&quot;&quot;>
<select name=&quot;LB1&quot;>
<%
Dim CN
Dim RS
Set CN=Server.CreateObject(&quot;ADODB.Connection&quot;)
CN.Open &quot;DSN=ISAH7&quot;
Set RS = CN.Execute(&quot;SELECT * FROM test&quot;)

While not RS.EOF
Respons.Write &quot;<option value=&quot; & RS.Fields(&quot;Stef&quot;) & &quot;>&quot; & RS.Fields(&quot;Stef&quot;) & &quot;</option>&quot;
RS.MoveNext
Wend

Set RS = nothing
CN.Close
Set CN=nothing
%>
</select>
</form>

 
I Already found the error. I forgot to type an E in Respons(e).Write

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top