Brian Kotek wrote:
> Hmm....no idea on this one. I've never seen this error before. Any other
> info you can provide?
>
here are sample cfm & cfc files...
Azadi
PS: not sure if i can attach files to posts to this list.... let's see...
<cfparam name="FORM.CompanyID" default="">
<cfparam name="FORM.records_per_page" default="1">
<cfset comps = querynew("CompanyName,CompanyID")>
<cfloop from="1" to="11" index="iii">
<cfset QueryAddRow(comps, 1)>
<cfset QuerySetCell(comps, 'CompanyName', 'Company#iii#')>
<cfset QuerySetCell(comps, 'CompanyID', iii)>
</cfloop>
<html>
<head>
<cfajaxproxy cfc="results3">
<cfif isdefined('form.search_btn')>
<script>
getSearchResults = function(page,pagesize,sortcol,sortdir,cid){
var sr = new results3();
sr.setCallbackHandler(useResults);
sr.setErrorHandler(gridError);
sr.aList2(page,pagesize,sortcol,sortdir,cid);
}
useResults = function(res){
var ttlrecords = res.TOTALROWCOUNT;
document.getElementById('ttlresults').innerHTML = ttlrecords;
var myGrid = ColdFusion.Grid.getGridObject('resultsGrid');
myGrid.getDataSource().loadData(res,false);
myGrid.reconfigure(myGrid.getDataSource(),myGrid.getColumnModel());
}
gridError = function(){};
updateForm = function(){
document.forms.records.secretfield.value='1';
document.forms.records.submit();
}
testgrid = function(){
//var myGrid = ColdFusion.Grid.getGridObject('resultsGrid');
/*ds = myGrid.getDataSource();
ds.loadData(useRe,false);
cm = myGrid.getColumnModel();
myGrid.reconfigure(ds,myGrid.getColumnModel());*/
ColdFusion.Grid.refresh('resultsGrid');
}
</script>
</cfif>
</head>
<body>
<span id="srCount"></span>
<!--- Form Start --->
<cfform action="advance_search31.cfm" method="post" name="records">
<input type="hidden" name="secretfield" value="">
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0"
id="content">
<tr>
<td colspan="4">
<!--- Search Engine Start --->
<table border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td valign="top" colspan="3">
<p>Select Company:</p>
<cfselect name="CompanyID"
query="comps"
display="CompanyName"
value="CompanyID"
selected="#form.CompanyID#"
size="5"
required="yes"
message="Please Choose a Company!"
class="textfield" />
</td>
</tr>
<tr>
<td colspan="3" valign="top" align="center">
<cfinput type="submit"
name="Search_btn"
value="Start Search"
class="button" />
</td>
</tr>
</table>
<!--- Search Engine End --->
</td>
</tr>
<!--- Won't display until the Search button is pressed --->
<cfif IsDefined('FORM.Search_btn')>
<tr>
<td colspan="2"><p>Click on the company name to see their page.</p></td>
<td colspan="2"><p>Total results: <span id="ttlresults"></span></p></td>
</tr>
<tr>
<td colspan="4" align="center">
<cfgrid name="resultsGrid" format="html"
pageSize="#form.records_per_page#" striperows="yes"
bind="javascript:getSearchResults({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},{records:[EMAIL
PROTECTED])"
bindonload="false">
<cfgridcolumn name="rownum" header="##" width="50"
headeralign="center">
<cfgridcolumn name="CompanyName" header="Company Name"
width="580" headeralign="left">
<cfgridcolumn name="profits" header="YTD Gross Profit"
width="120" headeralign="left">
<cfgridcolumn name="CompanyID" header="ID" width="0"
display="no">
</cfgrid>
</td>
</tr>
</cfif>
</table>
</cfform>
<!--- Form End --->
<cfset ajaxonload("testgrid")>
</body>
</html>
<cfcomponent output="yes">
<cfset basequery = querynew("rownum,CompanyName,CompanyID,profits")>
<cfset queryaddrow(basequery, 11)>
<cfloop from="1" to="11" index="iii">
<cfset QuerySetCell(basequery, 'rownum', iii, iii)>
<cfset QuerySetCell(basequery, 'CompanyName', 'Company#iii#',
iii)>
<cfset QuerySetCell(basequery, 'CompanyID', iii, iii)>
<cfset QuerySetCell(basequery, 'profits',
'#Dollarformat(RandRange(99999,999999999))#', iii)>
</cfloop>
<cffunction name="aList2" access="remote" returnType="struct" output="false">
<cfargument name="page" type="numeric" required="true">
<cfargument name="pagesize" type="numeric" required="true">
<cfargument name="sortcol" type="string" required="true">
<cfargument name="sortdir" type="string" required="true">
<cfargument name="cid" type="numeric" required="true">
<cfset var result = structNew()>
<cfset var data = "">
<cfquery name="data" dbtype="query">
SELECT * FROM basequery WHERE CompanyID = <cfqueryparam
cfsqltype="cf_sql_integer" value="#arguments.cid#">
</cfquery>
<cfset result = queryConvertForGrid(data, arguments.page,
arguments.pagesize)>
<cfreturn result>
</cffunction>
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290262
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
