DATA GRID ISSUES
I have;
Function and form code:
------------------------------------
<cfcomponent>
<cffunction name="getArtists" access="remote">
<cfargument name="page" required="yes">
<cfargument name="pageSize" required="yes">
<cfargument name="gridsortcolumn" required="yes">
<cfargument name="gridsortdirection" required="yes">
<cfquery name="members" datasource="pdgps" dbtype="ODBC">
SELECT autoid, CONVERT(VARCHAR(10), sDate, 101) as DATE, DAGRSN, branch,
DODAAC, clin, hours
FROM reporting.DAGRSCRAPS
<cfif gridsortcolumn neq ''>
order by #gridsortcolumn# #gridsortdirection#
</cfif>
</cfquery>
<cfreturn queryconvertforgrid(members,page,pagesize)/>
</cffunction>
<cffunction name="tester" access="remote" returntype="String">
<cfscript>
x = "Hello";
</cfscript>
<cfreturn x>
</cffunction>
</cfcomponent>
<cfinvoke component="components.artist" method="tester" returnvariable="Var">
<cfform name="tableform">
<cfgrid format="html" name="grid_Tables" pagesize="7" selectmode="row"
bind="cfc:components.artist.getArtists({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
<cfgridcolumn name="autoid" display="No"/>
<cfgridcolumn name="DATE" header="DATE" >
<cfgridcolumn name="DAGRSN" header="DAGRSN" >
<cfgridcolumn name="branch" header="SERVIVE" >
<cfgridcolumn name="DODAAC" header="DODAAC" >
</cfgrid>
</cfform>
<cfdump var="#Var#">
------------------------------------
Error is:
------------------------------------
The specified CFC artist could not be found.
The path to the CFC must be specified as a full path, or as a relative path from the current template, without the use of mappings.
The error occurred in \\Vboxsvr\g_drive\Backup\pdgps\admin\backoffice\test.cfm: line 11
9 : <cfgridcolumn name="DAGRSN" header="DAGRSN" >
10 : <cfgridcolumn name="branch" header="SERVIVE" >
11 : <cfgridcolumn name="DODAAC" header="DODAAC" >
12 : </cfgrid>
13 : </cfform>
--------------------------------------------------------------------------------
| The following information is meant for the website developer for debugging purposes. | ||||||||
| Error Occurred While Processing Request | ||||||||
| ||||||||
ANY IDEAS?
AdChoices