Wow - Thanks Ray! I didn't think that would be effecting (affecting?) that because I wasn't referencing it.... Boy was I wrong.
THANK YOU!!!! - Nick -----Original Message----- From: Raymond Camden [mailto:[email protected]] Sent: Tuesday, April 17, 2012 1:47 PM To: cf-newbie Subject: Re: cfselect not binding Your bind has one argument. Your CFC func has 2. On Tue, Apr 17, 2012 at 1:38 PM, Nick Sweeney <[email protected]> wrote: > > Howdy Everybody - > > I am hoping someone can spot the issue I can't - been beating my brow for awile now. > > I have a simple form - and I am trying to Bind a cfselect - and for some reason it is not getting the value of the bind - ? I have no idea why. > > So - rather than the select only getting 2-3 results - it brings up ALL results... Ideas? > > Thanks - Nick > > Code: > <cfform method="post" name="mycfform"> > > <cfselect name="DVID_NEW" query="GeDivisionListing" > display="DivisionName" value="DVID" queryposition="below" > selected="#GetTeamAnnualData.DVID#"> > <option value="0">Select a Division</option> > </cfselect> > > <cfselect name="ConfID_New" > bind="cfc:Football.ConferenceListing({DVID_NEW})" > display="fullDescription" value="ConfID" bindonload="true"> > </cfselect> </cfform> > > It looks to this Function: > <!--- > ====================================================================== > Get Conferences > ====================================================================== > ---> > <cffunction name="ConferenceListing" access="remote" > returntype="query" output="no"> > <cfargument name="ConfID" default="0"> > <cfargument name="DVID" default="0"> > > <cfset myResult="GetConferenceListing"> > > <cfquery name="GetConferenceListing" > datasource="#Application.DSN#" username="#Application.username#" > password="#Application.password#"> > SELECT ConfID , MCID , DVID , DivisionName , ConferenceName , > CONCAT('[',DivisionName, '] ', ConferenceName) AS > fullDescription > FROM fb_conferences > <cfif IsDefined("ARGUMENTS.DVID") AND ARGUMENTS.DVID > NEQ 0> > WHERE DVID = <cfqueryparam cfsqltype="cf_sql_integer" > value="#ARGUMENTS.DVID#"> > </cfif> > Order By DivisionName ASC > </cfquery> > > <cfreturn GetConferenceListing> > </cffunction> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5854 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
