Dropdown from DB field - parsing contents of field

<i><b>Originally posted by : L Cramer (lawrence@thecramers.com)</b></i><br />What I'm trying to do is, for example in the "size" filed you have....<br /> XS/XL, 2XL,3XL ]<br /><br />What I need to do is parse the contents of the field so the resulting data<br />populated drop-down for field on the web page looks like this....<br /><br />| Choose Size |>|<br /> XS/XL<br /> 2XL<br /> 3XL<br /><br />The user could then select a size and that choice would be sent to the cart<br />page along with the rest of the info. I've seen it done this way and makes<br />it very easy for the site owner to update the record. Dose this clear up<br />what I'm after? I need to do this for the Size and the Color fields.<br /><br />I am developing in Macromedia Dreamweaver UltraDev, if that helps.<br /><br />Thank you very much.<br /><br />Lawrence Cramer<br />lawrence@thecramers.com<br />

<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><br />Try this code (change the value of size to be equal to you recordset field):<br /><SELECT><br /><%<br />size = "XS/XL, 2XL, 3XL"<br /> <br />s = Split(size, ", ")<br />for p = 0 to UBound(s)<br /> Response.Write "<OPTION>" & s(p) & "</OPTION>" & vbCrLf<br />next<br />%><br /></SELECT><br /><br />Doug Seven<br />codejunkies.net / ASPNextGen.com (coming soon!)<br /><br />------------<br />L Cramer at 7/21/2000 11:57:44 AM<br /><br />What I'm trying to do is, for example in the "size" filed you have....<br /> XS/XL, 2XL,3XL ]<br /><br />What I need to do is parse the contents of the field so the resulting data<br />populated drop-down for field on the web page looks like this....<br /><br />| Choose Size |>|<br /> XS/XL<br /> 2XL<br /> 3XL<br /><br />The user could then select a size and that choice would be sent to the cart<br />page along with the rest of the info. I've seen it done this way and makes<br />it very easy for the site owner to update the record. Dose this clear up<br />what I'm after? I need to do this for the Size and the Color fields.<br /><br />I am developing in Macromedia Dreamweaver UltraDev, if that helps.<br /><br />Thank you very much.<br /><br />Lawrence Cramer<br />lawrence@thecramers.com<br />