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 Chriss Miller 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
Joined
Dec 9, 2000
Messages
27
Location
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