one long list comma seperated 2

[tyutghf]

I have some fields in a database that were created just as one column. If there are various options then they were written with a comma seperating them

i.e. a column may contain

qwe,rty,uio,asd,fhhj

I can pull this out of the database no problem with rs("allows"), is it possible to create a dropdown of these so that from the column the page displays

<option>qwe</option>
<option>rty</option>
<option>uio</option>
<option>asd</option>
<option>fhhj</option>

Thanks folks

 

[guitarzan]

Look into the Split() function

http://www.w3schools.com/VBscript/func_split.asp

As an example:

Dim arrAllows, s
arrAllows = Split(rs("allows"), ",")
For Each s In arrAllows
	response.write "<OPTION>" & s & "</OPTION>"
Next

 

[tyutghf]

That is great thanks, learing new stuff every day

 

[gmmastros]

Or....

Response.write "<option>" & replace(rs("allows"),",","</option><option>") & "</option>"

with a little fancy replacing you can skip the loop


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[tyutghf]

Thanks gmmastros that is a clever way of doing it