Cannot put <cfoutput> around a <select> statement usinga query.

Ask a Question related to Macromedia ColdFusion, Design and Development.

  1. #1

    Default Cannot put <cfoutput> around a <select> statement usinga query.

    <select name="t#this_tourn#_course_id">
    <cfoutput query="get_courses">
    <option value="#course_id#"> #course_name# - Par #par#</option>
    </select>

    Obviously, the variable 't#this_tourn#_course_id' in the <select> statement is
    not getting processed because it is not enclosed in <cfoutput> tags. Since I'm
    using a query for the OPTION, I don't know how to make this work. As far as I
    know, I can't use a CFSELECT because it will only display one column.

    There must be a fairly simple solution to this, but I am at a loss.

    Thanks.



    Bagger Vance Guest

  2. Similar Questions and Discussions

    1. question about SQL query and cfoutput with INNER JOIN
      I have a query that pulls data from two related tables (an Article Table and a Photo table, linked by ArticleID) Lets say i have 3 photos that are...
    2. CFOUTPUT QUERY rowcount = 0
      Hello, I have a query which return 0 row. I have a CFOUTPUT QUERY which try to output my query. Coldfudion enter in the CFOUTPUT once EVEN if my...
    3. Using cfoutput within a cfif statement
      I am trying to setup a form validation, what i need to do is look at the Specimen Number entered and compare it against the database to see if it...
    4. <cfoutput query> and TABLE formatting
      HI, I'm trying to output images from a database using <cfoutput query>. That part works fine. But the images display all in one column, one...
    5. SELECT statement
      I have 3 tables: table countryPrice: productID countryId price 1 Italy 90 1 England ...
  3. #2

    Default Re: Cannot put <cfoutput> around a <select> statementusing a query.

    Is there any reason <cfoutput<select name="t#this_tourn#_course_id"></cfoutput> wouldn't work?

    KevinOtt Guest

  4. #3

    Default Re: Cannot put <cfoutput> around a <select> statementusing a query.

    Well, son of a gun - that works. I didn't think you could split tags up like
    this, so I didn't even try it:

    <cfoutput> <select> </cfoutput> </select>

    I thought I would get a message about an ending </select> tage must have a
    matching start tag, but I guess that's only for ColdFusion Tags.

    Thanks!




    Bagger Vance Guest

  5. #4

    Default Re: Cannot put <cfoutput> around a <select> statementusing a query.

    While that does work it is still bad coding practice to incorrectly nest tags.

    You should do either:-

    <select name="<cfoutput>t#this_tourn#_course_id</cfoutput>">
    <cfoutput query="get_courses">
    <option value="#course_id#"> #course_name# - Par #par#</option>
    </cfoutput>
    </select>

    or

    <cfoutput>
    <select name="t#this_tourn#_course_id">
    <cfloop query="get_courses">
    <option value="#course_id#"> #course_name# - Par #par#</option>
    </cfloop>
    </select>
    </cfoutput>

    Stressed_Simon Guest

  6. #5

    Default Re: Cannot put <cfoutput> around a <select> statement using a query.

    > While that does work it is still bad coding practice to incorrectly nest tags.

    No, it's not because HTML is "noise" to CFML, it's not code.

    > <select name="<cfoutput>t#this_tourn#_course_id</cfoutput>">
    If there was a bad practice to be had regarding "nesting" HTML and CFML
    tags, this would be an example of it, I reckon.

    Embedding tags within one another surely is far worse than "incorrectly"
    nesting them?

    > <cfoutput>
    > <select name="t#this_tourn#_course_id">
    > <cfloop query="get_courses">
    > <option value="#course_id#"> #course_name# - Par #par#</option>
    > </cfloop>
    > </select>
    > </cfoutput>
    Yeah. This is what I'd do.
    Adam Cameron 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