Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Display alternate recordset

Example:
Table: FRUIT
column1:
apple
bananas
grapes

column2:
I like apples.
I like bananas.
I like grapes.

I'm trying to have it where the choices from column1 are provided on the form, and based on the what was chosen on the form the corresponding choices from column2 are display on the page.

Comments

  • FlakesFlakes Member Posts: 642
    : Example:
    : Table: FRUIT
    : column1:
    : apple
    : bananas
    : grapes
    :
    : column2:
    : I like apples.
    : I like bananas.
    : I like grapes.
    :
    : I'm trying to have it where the choices from column1 are provided on the form, and based on the what was chosen on the form the corresponding choices from column2 are display on the page.
    :

    [code]
    Set rs=yourconnection.Execute("Select * from FRUIT")
    While not rs.EOF

    If rs(0)=Request("yourselectname") Then
    response.Write rs(1)
    End If
    rs.MoveNext

    Wend
    [/code]

    or

    [code]
    Set rs=yourconnection.Execute("Select Field2 from FRUIT Where Field1='"&Request("yourselectname") &"'")
    If not rs.EOF

    response.Write rs(0)
    End If


    [/code]


    Something like that ??


Sign In or Register to comment.