Skip to main content
Inspiring
February 16, 2009
Question

ajax help please

  • February 16, 2009
  • 1 reply
  • 593 views
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>
This topic has been closed for replies.

1 reply

Inspiring
February 17, 2009
Hi,

Why can't you make the select box as a mandatory field to be entered so that it will push the user to select a value from the list of values presented with the drop down?.

LithcauseAuthor
Inspiring
February 17, 2009
ok i can do that but i am just not sure on how to have the multiple select update that on the fly... or even pull the names of the category that they have chosen before because i cant have a query on that page that gets the info i need that = #cid# because cid is binding to the drop downs so noe is selected right away...

ok lets see here ... how can i call a query from the cfc page to the cfm one that way i can bind it on the cfc and possibly pull the info i need...