CodingForums.com - Concate Multiple Rows

CodingForums.com (http://www.codingforums.com/index.php)

- ASP (http://www.codingforums.com/forumdisplay.php?f=8)

- - Concate Multiple Rows (http://www.codingforums.com/showthread.php?t=266479)

Concate Multiple Rows

Hello,

I have a table something like this:
Category .. Item Number .. Item Description
Item1 ...... Number 1 ....... Description1
Item1 ...... Number 2 ....... Description2
Item2 ...... Number 3 ....... Description1
Item3 ...... Number 1 ....... Description3

It needs to output some thing like this:
Item1, Number1, Number2 .. Description1, Description2
Item2, Number3... Description1
Item3, Number1... Description3

The output info will go into Dropdowns for all three fields in a form.

Any help is extremely useful, stuck on this issue for few weeks. Could not find any thing online.

I am programming in classic asp and Microsoft Access DB.

??? Do you mean your DATABASE table looks like that? Or your HTML <table> does?

If you mean the DATABASE table, then are you saying you need to have

Code:

<tr>

    <td>Item1</td>

    <td><select ...>

        <option>Number 1</option>

        <option>Number 2</option>

        </select>

    </td>

    <td><select ...>

        <option>Description 1</option>

        <option>Description 2</option>

        </select>

    </td>

</tr>

in the HTML output?

Thanks for the reply, I did figure it out.