> 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