If I have the EXACT same code in two places, one inside
INTERNAL, one in ROOT, and one binds, shouldn't the other bind?
Also, I used CFDEBUG and it just says there's an uncaught
error on 799. If I do a view source the file has less than 450
lines, the source file has 160 lines. Where is this number coming
from?
My grid:
<cfform name="test">
<cfgrid name="dealer_grid" format="html"
bind="cfc:data.get_dealers({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"
striperows="true" striperowcolor="gray">
<cfgridcolumn name="pa_code" header="P&A Code"/>
<cfgridcolumn name="dealership_name" header="Dealership
Name"/>
<cfgridcolumn name="pending" header="Pending"/>
<cfgridcolumn name="immediate" header="Immediate"/>
<cfgridcolumn name="strategy" header="Strategy"/>
<cfgridcolumn name="status" header="Status"/>
</cfgrid>
</cfform>
data.cfc:
<cfcomponent displayname="data.cfc" output="false">
<cffunction name="get_dealers" access="remote"
output="no">
<cfargument name="page" default="">
<cfargument name="pageSize" default="">
<cfargument name="gridsortcolumn" default="">
<cfargument name="gridsortdirection" default="">
<cfquery name="get_dealers" datasource="admi-prod">
SELECT dm.pa_code, dm.dealership_name, dm.dealer_id,
fd.fad_employee_id, fe.lastname,
nvl(to_char(fd.pending_return_month), 'N/A')
pending_return_month,
nvl(to_char(fd.immediate_return_month), 'N/A')
immediate_return_month,
decode(strategy, 1, 'Aggressive', 2, 'Moderate', 3,
'Conservative', 'N/A') strategy,
fd.status
FROM dealer_master dm, fad_dealers fd, fad_employees fe
WHERE fd.dealer_id = dm.dealer_id
AND fe.fad_employee_id(+) = fd.fad_employee_id
AND dm.primary_manufacturer_id = 1
AND dm.termination_date IS NULL
AND fd.fad_employee_id = fe.fad_employee_id
AND fe.user_id = 52663
</cfquery>
<cfreturn queryConvertForGrid(get_dealers, page,
pageSize)>
</cffunction>
</cfcomponent>