Use queryaddrow to add an extra row to the query with whatever values you need.
-----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 11:54 AM To: CF-Talk Subject: CFSELECT part 2 In another attempt to solve my earlier problem... My participant list is based on a query of a table of our participants. Is there a way to create a CFSELECT box that ADDS an additional field that is blank, in cases where no participant is needed? In theory I could make that item "not required" but if a user makes a selection from that CFSELECT and then realizes that it should be blank, they can't clear the selection without refreshing the entire form and starting over. So, what I am after is a CFSELECT based on the results of a query AND one additional blank item. TIA, Tim ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202210 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
