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