I have a memo field seperated with commas with a value of Blue, Green, Yellow, Orange. How do I get that into a drop down menu so each color is a seperate choice? Thanks. I'm using ASP/Access.

Dear Crowe,

msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctsplit.asp

Regards,
Brent

Thanks, bcolflesh. That explains how to get the data out of the string to me, but I still don't know how to put that into a menu drop down. Any ideas? Thanks again.

Hi,

This code isn't bulletproof, and I haven't tested it, but I think it's about good
<pre id=code><font face=courier size=2 id=code>
&lt;%

Dim Array
Dim iArrayLength, i
.........
Code for creating the 'best' recordset ever
.........

Array = Split( rsRec("Memofield", ","
iArrayLength = UBound(Array)

Response.Write(" &lt;select name="""something"""&gt; " )
For i = 0 to iArrayLength
Response.Write("&lt;option value='" & Array(i) & "'&gt;" & Array(i) & "&lt;/option&gt;" & vbCr)
Next
Response.Write(" &lt;/select&gt; " )

%&gt; </font id=code></pre id=code>

Think that should do the trick, if I have understood you right...

Stanly,
That's exactly what I'm after. But the code you provided didn't work. I think it has something to do with the way your &lt;select&gt; tags are placed. Could you possibly look that over? Maybe give me another version? Thanks.

&lt;%
Dim Array
Dim iArrayLength, i

.........
Code for creating the 'best' recordset ever
.........

Array = Split( rsRec("Memofield", ","
iArrayLength = UBound(Array)

Response.Write("&lt;select&gt;" )

For i = 0 to iArrayLength
Response.Write("&lt;option value='" & Array(i) & "'&gt;" & Array(i) & "&lt;/option&gt;" & vbCr)
Next

Response.Write("&lt;/select&gt;" )

%&gt;

Or you could do something like this, even:


&lt;select&gt;


&lt;%
Dim Array
Dim iArrayLength, i

.........
Code for creating the 'best' recordset ever
.........

Array = Split( rsRec("Memofield", ","
iArrayLength = UBound(Array)

For i = 0 to iArrayLength
Response.Write("&lt;option value='" & Array(i) & "'&gt;" & Array(i) & "&lt;/option&gt;" & vbCr)
Next
%&gt;

&lt;/select&gt;


Does this help? If not, can you give me a little description of what it does? The string is *only* seperated by commas, right, no spaces or anything? If there are more, you must edit the second parameter of the split function.

Stanly

Stanly,
That works great if I put that on a blank page but for some reason when I put it into my current page it generates errors like this:

Microsoft VBScript runtime error '800a000d'
Type mismatch
/alphadog/products/detail.asp, line 9



Here is the code that is on that page at line 9:

UCII_CartColNames = Array("ProductID","Quantity","Name","Price","Total"


It's using the UltraCart II, does that help? Thanks so much for all of your help.

The mismatch is probably the array, which as you write it, is a 5-dimentional array(!)

You got a memofield, which got a string in it, with 5 elements seperated by commas, right? I understood it like in the drop-down, you wanted those 5 elements... Is this correct, or do you want all 5 elements in each line, with each line being a new record in the db?

The code should be able to adapt to both cases, but my code is for the first version...

First, let me say I'm very new to arrays and using them. Second, the array that you and I have been working on could have 1 element or many. It's a multiple select box where the administrator can choose which colors that specific product is available in. For example, a rubber chew toy for dogs could be available in black, green, red, blue. But a different chew toy could be available in just red. Does this make sense? I hope so. That's what I'm trying to do. Any more ideas? Thanks again.

Could you mail me a copy of the file at edata@emerslund.no , so I could take a closer look at it? That would probably be the best way for me to make sure what is happening....