here's my code:
Code:<%
set conn = server.createobject("ADODB.Connection")
set rs = server.createobject("ADODB.Recordset")
conn.provider = "Microsoft Jet 4.0 OLE DB Provider"
conn.connectionString="i:\wwwroot\bayteksystems\clients\designshirt\db\designshirt.mdb"
conn.open()
set rs=conn.execute("SELECT * FROM tblCategory ORDER BY categoryName ASC")
categoryArray=rs.getRows
set rs=conn.execute("SELECT * FROM tblStyle ORDER BY styleName ASC")
styleArray=rs.getRows
set rs=conn.execute("SELECT * FROM tblColor ORDER BY colorName ASC")
colorArray=rs.getRows
conn.close()
%>
<html>
<body>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<select name="category">
<%
for x = 0 to ubound(categoryArray,2)
response.write "<option value=" & categoryArray(0,x) & ">" & categoryArray(1,x) & "</option>" & vbcrlf
next
%>
</select>
</td>
</tr>
</table>
</body>
</html>
click here to see
in explorer it's ok,since i start programming that is how i do it!!
it's just a select box, but in netscape, instead of a select,
it put the word one after each other!!
if you have netscape please click on the link!!
