Can you pass a session variable in a CFC bind?

@Libby H

There are 2 things.

1) The name of the component the grid binds to(distinctComponents) is different from the name of the CFC(getDistinct).

2) Session variables are also available to components. There is therefore no need to pass them explicitly to a function. In any case, it is always advisable to test for the existence of a session variable before using it.

Your code would then be something like

<cfform>
     <cfgrid name="componentsGrid"
             format="html"
             pagesize=10
             striperows="yes"
             bind="cfc:distinctComponents.getDistinct({cfgridpage},{cfgridpagesize },{cfgridsortcolumn},{cfgridsortdirection})"
             selectmode="row" >
         <cfgridcolumn name="Component_type" header="Component Type" width="400">
     </cfgrid>
</cfform>

</cfwindow>

<!---distinctComponents.cfc--->

<cfcomponent>
    <cffunction name="getDistinct" access="remote" returntype="struct">
        <cfargument name="page">
        <cfargument name="pageSize">
        <cfargument name="gridsortcolumn">
        <cfargument name="gridsortdir">
  <cfset var Qcomponents = ''>

    <cfif gridsortcolumn EQ "">
   <cfset gridsortcolumn = "ASC">
  </cfif>
        <cfif gridsortdir EQ "">
   <cfset gridsortdir = "ASC">
  </cfif>
<cfparam name="session.this_appl" default="your_default_value">
   <cfquery name="Qcomponents" datasource="Tax">
      select DISTINCT(component_type) from ctl_components 
     where app_abbrev = #session.this_appl#
   </cfquery>
    <cfreturn QueryConvertForGrid(Qcomponents, page, pageSize)>
  </cffunction>

</cfcomponent>

If your session variable is a string, then you need to pass its value to the JS function as a string: it needs quotes around it.

As another respondent said: use a CFQUERYPARAM in your query, too.  This has got nothing to do with your current predicament, but one should never hard-code dynamic values into an SQL statement.

--

Adam

Hi Libby,

It looks like you're simply trying to pass the SESSION.variable into your SQL WHERE statement.  You can take this out of your BIND statement, and out of your ARGUMENTS statement.  Just pass it into your WHERE statement.

Just pass it into your WHERE as: (if you're passing a number)

where app_abbrev = #session.this_appl#

Just pass it into your WHERE as: (if you're passing a string)

where app_abbrev = '#session.this_appl#'

*I also note you're trying on your original bind to pass in the #se... variable.  Make sure when you're building these to have opening and closing braces {...}.  You don't need it, but for future reference.

<cfwild />