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:5853
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm

Reply via email to