|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: how to fill a combo from a database |
|
From: |
Marco Kawollek |
|
Date: |
1/21/2000 9:51:26 AM |
|
IP: |
130.75.232.158 |
Do your connection and SQL commands as usual.
When youve got the Recordset with the data, then insert the following code:
For example you have colums for the value and the text in your database you can use this:
<select name=anyname>
<%
Do until Recorsetname.EOF
%><option value="<%=DatanamefromRecordset%>"><%=TextnamefromRecordset%></option><%
Loop
%>
Then close Connection and Recordset as usual and you have a beautiful combo.
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
