Question
ajax help please
the form i have created has a part that will have a multiple
select... it will have 3 tables. one table will have the names of
the categories with a id as CatId{primry key}.
the second is the members table that has the memberRecordId{primary key}, CId{linked to contacts table}, and memberYear.
then the last table is the CategoryData table that has the CatDataId{primary key}, CatId{linked to category table}, and the MemberRecordId{linked to the members table}...
so the select looks like this
<cfselect enabled="Yes" name="memberCategory" class="SELECT" label="Category" multiple="yes" width="200" height="80" size="8" >
<cfoutput query="getcat">
<option value="#trim(CatId)#">#trim(Category)#</option>
when i select something it shows up in the cfdebug for ajax... but what if they dont select something? how would i have the update work? or does someone have a better idea on how i should do this?
</cfoutput> </cfselect>
the second is the members table that has the memberRecordId{primary key}, CId{linked to contacts table}, and memberYear.
then the last table is the CategoryData table that has the CatDataId{primary key}, CatId{linked to category table}, and the MemberRecordId{linked to the members table}...
so the select looks like this
<cfselect enabled="Yes" name="memberCategory" class="SELECT" label="Category" multiple="yes" width="200" height="80" size="8" >
<cfoutput query="getcat">
<option value="#trim(CatId)#">#trim(Category)#</option>
when i select something it shows up in the cfdebug for ajax... but what if they dont select something? how would i have the update work? or does someone have a better idea on how i should do this?
</cfoutput> </cfselect>
