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!!




Reply With Quote