> I have a CFQUERY from an Access table that puts a set of 
> USER_IDs into a result set that then gets put into a CFSELECT 
> list. How do I add an item to the result set (the CFSELECT 
> list) after the CFQUERY has been made?

There are a couple of ways you can do this. The easiest is probably to
simply add an OPTION tag within your CFSELECT:

<cfselect name="mUSER_ID" size=1
         query="GET_USERS"
         value="USER_ID"
         display="USER_ID">
           <option value="0">None of Above
</cfselect>

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to