Hi,
I have a select box populated from a query 'UserCategory' as follows:
(the query:)
------------
<cfquery name="UserCategory"
datasource="X"
dbtype="ODBC">
SELECT UserCatID, UserCategory
FROM dbo.UserCategories
ORDER BY UserCategory
</cfquery>
The HTML/CFMl code in CFFORM
<cfselect name="UserCategory" size="1" message="Please select or type in
your classification." query="UserCategory" value="UserCategory"
display="UserCategory">
<option value="" selected>
</cfselect>
I want the user to be able to:
a)- add or type in a new category if it is NOT listed or not in the database
-(the select box from the above code doesnt allow any input/typing in -
seems read only)
b)- if a new category is added in the select box, it is added to the
UserCategories table. (Do I just do it by an update query or is there a
ready made tag for this kind of action)
Could someone please tell me if that is possible or not...have searched for
such a tag and reviewed this forum
Please Help, would appreciate any advice or comment
Thanks in advance
Nashir
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
