can anyone sort this for me. The first "write line where I try to specify te option value. So far I've managed to display the value but not as the hyperlink. Very frustrating!!
Cheers!
rs.Open Sql, conn
response.write("<form>"
response.write("<select size=3>"
do until rs.EOF
for each x in rs.Fields
with Response
.write("<option value="<a href='eventDefault.asp?eventcode="& sectionId &"&store="& newV2 &"&eventdate="& d1 &"&event="& x.value &"&hWeek="& week&"&hYear="& year &"'>""
.write(x.value)
.write("</a></option>"
end with
next
rs.MoveNext
loop
rs.close
response.write("</select>"
response.write("</form>"
Cheers!
rs.Open Sql, conn
response.write("<form>"
response.write("<select size=3>"
do until rs.EOF
for each x in rs.Fields
with Response
.write("<option value="<a href='eventDefault.asp?eventcode="& sectionId &"&store="& newV2 &"&eventdate="& d1 &"&event="& x.value &"&hWeek="& week&"&hYear="& year &"'>""
.write(x.value)
.write("</a></option>"
end with
next
rs.MoveNext
loop
rs.close
response.write("</select>"
response.write("</form>"