Multiple DB Columns display in <cfselect display>

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

  1. #1

    Default Multiple DB Columns display in <cfselect display>

    *disclaimer* -- I'm a CF n00b.

    Hello all,


    J. Random Guest

  2. Similar Questions and Discussions

    1. how to display data in 3 columns by 4 rows format
      All, I will be eternally greatful if someone can provide snippet of code, URL or reference material that shows how to display data in a "n...
    2. Can we bind the values from cfselect to display thoseinto cfinput text boxes.
      Hi, I have a cfselect box which is having values from cfquery. I want to bind those values into few input boxes. I have been trying for so many...
    3. displaying multiple columns in <cfselect>
      ok, I have a database that house a table called model. The model contains a manufacturer foreign key and 3 other fileds for that table. I want...
    4. Display query columns picture & TEXT
      Okay, I was able to display my product pictures in 2 rows of 3 columns using the MOD function. Only problem is, I want to nest in my product...
    5. want to display 2 variables in cfselect
      HI! It is been years since I played with coldfusion... I can't remember how to display 2 variables in a cfselct.. I would like to do something...
  3. #2

    Default Multiple DB Columns display in <cfselect display>

    *disclaimer* -- I'm a CF n00b.

    Hello all,


    forumnotifier Guest

  4. #3

    Default Multiple DB Columns display in <cfselect display>

    *disclaimer* -- I'm a CF n00b.

    Hello all,


    J. Random Guest

  5. #4

    Default Multiple DB Columns display in <cfselect display>

    *disclaimer* -- I'm a CF n00b.

    Hello all,


    J. Random Guest

  6. #5

    Default Re: The real post - Multiple DB Columns display in<cfselect display>

    Welcome :-)

    Just string the first and last name together as a single column in your query.
    Then use that column name in your cfselect. For example:

    --- query was not tested!
    SELECT FirstName +' '+ LastName AS FullName
    FROM yourTable

    <cfselect display="FullName" ....etc... >

    Tip, it is a good idea to get into the habit of not using SELECT * FROM Table.
    Only select the columns you need. SELECT * makes the database work harder and
    returns more information than you probably need, which can slow down
    performance.

    mxstu Guest

  7. #6

    Default Re: The real post - Multiple DB Columns display in<cfselect display>

    are you using <cfform>.... </cfform>?

    jorgepino 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