two select rethink - user fiendly?

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default two select rethink - user fiendly?

    I am using the cf two select related tag from the exchange and have great
    sucess with it populating the drop down menus
    I simple entered my categories manually into to the option sections so i can
    get and area and language mix.
    central area + English etc

    My question
    On my search page i have the drop downs populating but how do i get what the
    user has chosen to query on the result page.
    First i must write the sql - then
    What do i have to conider?
    Any advice most appreciated
    P.s Thanks dan for making me rethink where i was going with the project many
    thanks

    quiero mas Guest

  2. Similar Questions and Discussions

    1. Select user for cam: no users in list
      hey everyone i have setup flashmediaserver2 (win) and it connects and all that, but users arent appearing in the select user pulldown? i have opened...
    2. New user can't select text
      Hi Folks, Just got Illustrator CS after years of using AI8 and I'm bogged down already! I'm building a web page, so I started with the "blank"...
    3. Select all the user table
      Hi, Is there a way to select all user tables? For example, I created 5 tables. In SQL analyer, I want to select table name and strutures of tables...
    4. user cannot select systables
      All, I'm new to Informix but not new to databases. I have a user who cannot select from the systables in their own database. As user informix...
    5. SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
      Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id,
  3. #2

    Default Re: two select rethink - user fiendly?

    Originally posted by: quiero mas
    I am using the cf two select related tag from the exchange and have great
    sucess with it populating the drop down menus
    I simple entered my categories manually into to the option sections so i can
    get and area and language mix.
    central area + English etc

    My question
    On my search page i have the drop downs populating but how do i get what the
    user has chosen to query on the result page.
    First i must write the sql - then
    What do i have to conider?
    Any advice most appreciated
    P.s Thanks dan for making me rethink where i was going with the project many
    thanks

    I think the way I did it was.
    For select number 1 (which controls number 2), run a query to get the selected
    value. That part is easy.

    For select number 2, you need two queries. The first is a Q of Q from all
    available values to get just those that are related to the selected value in
    select 1. The second is to get the selected value.

    Or it might have been something else. All that stuff is at work. I am not.

    Dan Bracuk Guest

  4. #3

    Default Re: two select rethink - user fiendly?

    Ok ill give it a try - as you say te first one should be too much trouble. However the second one is going to be tuff.
    thanks again
    Mark
    quiero mas Guest

  5. #4

    Default Re: two select rethink - user fiendly?

    Originally posted by: quiero mas
    Ok ill give it a try - as you say te first one should be too much trouble.
    However the second one is going to be tuff.
    thanks again
    Mark

    Actually, it's even easier. You already have the js function written. Just
    call it as part of your body onLoad event handler.


    Dan Bracuk Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139