Change the CFC and rebuild the queries (using QueryAddRow and QuerySetCell)
to insert a "blank" record at the first position in the recordset (for all
the methods). Set it to have a empty ("") as value and the display "Please
select" (or whatever you like).I've done this here: https://www.pagina22.com.br/index.cfm?fuseaction=assinaturaFormulario&[EMAIL PROTECTED] You can see the three select-related in "Setor de atuação" -> "Segmento de atuação" -> "Atividade de atuação" fields (almost in the end of the form). Sorry, in portuguese. []'s Alex On Nov 16, 2007 12:24 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I'm using three cfselects for a "three selects related" setup. > Each is bound "bind" to a cfc. Works great. > > However, I'd like to get the select boxes to just display "please select" > instead of the first value of the query it looks up. I can do this with the > second and third cfselect since I can set those to trigger onclick . > > My first cfselect named "make": > > <cfselect name= "make" bind= "cfc: > michelinmoto.model.getfitmentdata.getMakes()" value= "make" > display= "make" bindonload= "true" multiple= "no" > > <option value = "" >please select > </cfselect> > > My second cfselect uses: > > bind= "cfc:getdata.getmodels([EMAIL PROTECTED])" My third cfselect uses: > > bind= "cfc:getdata.getyears({model},[EMAIL PROTECTED])" > > Is there a trigger I can use to have the first cfselect just show "please > select" and load the data when a user clicks on it? I tried various forms of > [EMAIL PROTECTED] with no luck. > > -jeff > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
