|
Mailing Lists
|
Home /
Groups /
ColdFusion Newbie (CF-Newbie)
cfselect not binding
Howdy Everybody -Nick Sweeney 04/17/12 02:39 P Your bind has one argument.Raymond Camden 04/17/12 02:47 P Wow - Thanks Ray!Eric Nicholas Sweeney 04/17/12 02:50 P 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> Your bind has one argument. Your CFC func has 2. ----- Excess quoted text cut - see Original Post for more ----- 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 Your bind has one argument. Your CFC func has 2. > > 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? ----- Excess quoted text cut - see Original Post for more -----
|
May 19, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||