User manual MACROMEDIA COLFUSION MX 7-CFML REFERENCE

[. . . ] COLDFUSION MX 7 ® CFML Reference Trademarks 1 Step RoboPDF, ActiveEdit, ActiveTest, Authorware, Blue Sky Software, Blue Sky, Breeze, Breezo, Captivate, Central, ColdFusion, Contribute, Database Explorer, Director, Dreamweaver, Fireworks, Flash, FlashCast, FlashHelp, Flash Lite, FlashPaper, Flex, Flex Builder, Fontographer, FreeHand, Generator, HomeSite, JRun, MacRecorder, Macromedia, MXML, RoboEngine, RoboHelp, RoboInfo, RoboPDF, Roundtrip, Roundtrip HTML, Shockwave, SoundEdit, Studio MX, UltraDev, and WebHelp are either registered trademarks or trademarks of Macromedia, Inc. and may be registered in the United States or in other jurisdictions including internationally. Other product names, logos, designs, titles, words, or phrases mentioned within this publication may be trademarks, service marks, or trade names of Macromedia, Inc. or other entities and may be registered in certain jurisdictions including internationally. [. . . ] They are, however, included in the generated XML. Usage This tag requires an end tag and can include HTML option and optgroup child tags. To ensure that a selected list box item persists across postbacks, use the cfform preserveData attribute with a list generated from a query. (This strategy works only with data that is populated from a query. ) If the cfform preserveData attribute is true and the form posts back to the same page, and if the control is populated by a query, the posted selection(s) for the cfselect control are used instead of the Selected attribute. For controls that are populated with regular HTML option tags, the developer must dynamically add the Selected attribute to the appropriate option tag(s). The group option generates a query using SQL GROUP BY syntax and places the value column entries from each group in an indented list under the group column's field value. This option generates an HTML optgroup tag for each entry in the group column. Close each HTML option tag in the cfselect tag body with a </option> end tag. If you do not do so, and you specify queryPosition="below", the first item from the query might not appear in the list. For more information, see the cfform tag entry. Example The following example lets you select one or more employee names from a list of all employees, grouped by departments, and displays the selected names and the employee's email addresses. It includes an option to get data for all employees. <!--- Get the employee names from the database. ---> <!--- Use SQL to create a Name field with first and last names. ---> <cfquery name = "GetAllEmployees" dataSource = "cfdocexamples" cachedwithin="#createTimeSpan(0, 1, 0, 0)#"> SELECT Emp_ID, EMail, Phone, Department, FirstName, LastName, FirstName +' ' +lastName as Name FROM Employees GROUP BY Department, Emp_ID, EMail, Phone, FirstName, LastName, FirstName </cfquery> <h2>cfselect Example</h2> <!-- The cfif statement is true if the form was submitted. 390 Chapter 2: ColdFusion Tags Show the selected names. ---> <cfif IsDefined("form. employeeid")> <!--- The form was submitted. ---> <h4>You Selected the following employees</h3> <cfif form. employeeid IS ""> <!--- Select All option was selected. ---> <cfoutput query="GetAllEmployees"> #name#<br> Email: #email#<br><br> </cfoutput> <cfelse> <!--- Use a query of queries to get the data for the selected users. Form. employeeid is a comma-delimited list of selected employee IDs. ---> <cfquery name = "GetSelectedEmployees" dbtype="query"> SELECT Emp_ID, EMail, Phone, Department, FirstName, LastName, FirstName +' ' +lastName as Name FROM GetAllEmployees WHERE Emp_ID in (#form. employeeid#) </cfquery> <!--- Display the names and e-mail addresses from the query. ---> <cfoutput query="GetSelectedEmployees"> #firstName# #lastName#<br> Email: #email#<br> <br> </cfoutput> </cfif> </cfif> <!--- The cfform tag posts back to the current page. ---> <h3>Select one or more employees</h3> <cfform action = "#CGI. SCRIPT_NAME#"> <!--- Use cfselect to present the query's LastName column, grouped by department. Allow Multiple selections. ---> <cfselect name = "employeeid" size = "15" multiple="yes" required = "Yes" message = "Select one or more employee names" query = "GetAllEmployees" group="Department" display ="name" value ="emp_id" queryPosition="Below"> <!--- Add an option to select all employees. ---> <option value = "">Select All</option> </cfselect><br><br> <input type="Submit"> </cfform> cfselect 391 cfservlet Description This tag is deprecated. [. . . ] The params argument is required for POST operations. The path to the directory in which to store files. When using the path argument, the file argument is required. For GET operations, defaults to the name specified in the url argument. [. . . ]