I was trying to put together a CFGRID as part of a business case to upgrade
to CF8 at my company. I've played with it before and have a working example
and when I try to recreate it using different component and data I get this
message in the CFdebug, "window:*global*: Exception thrown and not caught"
Here is my code broken down to as simplistic as possible and I'm still
getting it:
<cfoutput>
<cfform name="myform">
<cfgrid name="reportsGrid" format="html" pageSize="5" selectmode="row"
bind="cfc:acct_db.GetPOsCF8({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
<cfgridcolumn name="POreqid" display="No"/>
<cfgridcolumn name="formnumber" header="formnumber">
<cfgridcolumn name="project_number" header="Project">
<cfgridcolumn name="project_name" header="Project Name">
<cfgridcolumn name="market" header="Market">
<cfgridcolumn name="request_by" header="Request By">
</cfgrid>
</cfform>
</cfoutput>
the function I'm calling:
<CFFUNCTION name="GetPOsCF8" access="remote">
<cfargument name="page" required="yes">
<cfargument name="pageSize" required="yes">
<cfargument name="gridsortcolumn" required="yes">
<cfargument name="gridsortdirection" required="yes">
<CFQUERY name="q" datasource="#REQUEST.dsn#">
SELECT POreqid, formnumber, project_number, project_name, market,
request_by
FROM tblacct_POrequests
<cfif gridsortcolumn neq ''>
order by #gridsortcolumn# #gridsortdirection#
</cfif>
</CFQUERY>
<cfreturn queryconvertforgrid(q,page,pagesize)/>
</CFFUNCTION>
that's all of my code. Can somebody please tell me what I'm missing or
doing wrong?
Thanks,
Jeff
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
