Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry 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.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,519
    Thanks
    77
    Thanked 4,381 Times in 4,346 Posts
    ??? 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?
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the reply, I did figure it out.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •