Question

How do I use cfgrid with multiple additional arguments?

Asked by: av8or16

I am having difficulty generating cfgrid. I have tried a number of different configurations and I recieve different error messages for each.

When I surround each new argument in braces (bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, {companyIncl}, etc)...

I get the error message: 'Element not found: Country1 [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]' repeated for a number of arguments.

Followed by the error message: ' Error invoking CFC /data/production/cfc/Production.cfc : Not Found [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]' repeated for a number of arguments.

Followed by the error message: 'Bind failed, element not found: Country1 [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]' repeated for a number of arguments.

I then have to end Firefox through the task manager to stop recieving the error message loop.

When I simply list the arguments (bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, companyIncl, etc)...

I recieve an error message in firebug saying:

companyIncl is not defined
anonymous()28 (line 9)
anonymous()cfgrid.js (line 498)
anonymous(Object params=Object)data.js (line 11)
anonymous("grid_Tables", "__CFGRID__tableform__grid_Tables", "tableform", true, Object name=edit value=false, true, Object name=_24d value=false, [Object header=Company colName=COMPANY name=COMPANY, Object header=Country colName=COUNTRY name=COUNTRY, Object header=Field colName=FIELD name=FIELD, 23 more... 0=Object 1=Object 2=Object 3=Object 4=Object 5=Object], Object data=Object baseParams=Object paramNames=Object, true, true, Object name=_252 value=false, "#cfgrid1255933313782 .x-grid-col-0{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-0{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-1{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-1{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-2{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-2{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-3{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-3{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-4{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-4{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-5{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-5{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-6{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-6{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-7{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-7{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-8{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-8{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-9{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-9{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-10{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-10{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-11{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-11{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-12{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-12{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-13{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-13{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-14{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-14{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-15{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-15{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-16{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-16{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-17{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-17{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-18{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-18{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-19{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-19{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-20{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-20{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-21{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-21{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-22{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-22{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-23{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-23{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-24{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-24{color:#0B333C;} #cfgrid1255933313782 .x-grid-col-25{color:#0B333C;} #cfgrid1255933313782 .x-grid-hd-25{color:#0B333C;} #cfgrid1255933313782 .x-grid-row-selected{background-color:#7FCDFE !important;color:white} ", 25, true, Object name=_256 value=false, Object name=_257, Object name=_258, Object appendKey=true colInfo=[26], Object name=_25a, Object name=_25b, [])cfgrid.js (line 57)
anonymous()28 (line 12)
anonymous()cfajax.js (line 1096)
anonymous()cfajax.js (line 897)
anonymous(XMLHttpRequest onreadystatechange=has no toString() function, function(), div#resultdiv)cfajax.js (line 172)
anonymous()cfajax.js (line 125)
[Break on this error] _dd=_e6+1;\ncfajax.js (line 1007)

When I surround each new argument in single quotations (bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, 'companyIncl', etc)...

I get the error message: ' Error invoking CFC /data/production/cfc/Production.cfc : Not Found [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]'

When I only include the required cfgrid argumenst (bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})...

I get the error message: ' Error invoking CFC /data/production/cfc/Production.cfc : Element MINYEAR is undefined in FORM. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]'

---CFC---
 
<cffunction name="getProduction2" access="remote" returntype="any">
    
    <cfargument name="page" required="yes">
        <cfargument name="pageSize" required="yes">
        <cfargument name="gridsortcolumn" required="no">
        <cfargument name="gridsortdirection" required="no">
    <!--- Include/Exclude Arguments --->
		<cfargument name="companyIncl" type="string" required="false" default="false">
        <cfargument name="countryIncl" type="string" required="false" default="false">
        <cfargument name="regionIncl" type="string" required="false" default="false">
        <cfargument name="basinIncl" type="string" required="false" default="false">
        <cfargument name="fieldIncl" type="string" required="false" default="false">
        <cfargument name="waterCatIncl" type="string" required="false" default="false">
        <cfargument name="waterDepthIncl" type="string" required="false" default="false">
        <cfargument name="APICatIncl" type="string" required="false" default="false">
        <cfargument name="APIGravityIncl" type="string" required="false" default="false">
        <cfargument name="maturityIncl" type="string" required="false" default="false">
        <cfargument name="statusIncl" type="string" required="false" default="false">
        <cfargument name="sourceRockIncl" type="string" required="false" default="false">
        <cfargument name="productionSystemIncl" type="string" required="false" default="false">
        <cfargument name="gasQualityIncl" type="string" required="false" default="false">
        <cfargument name="harshConditionIncl" type="string" required="false" default="false">
        <cfargument name="processingIncl" type="string" required="false" default="false">
        <cfargument name="recoveryCatIncl" type="string" required="false" default="false">
        <cfargument name="operatedIncl" type="string" required="false" default="false">
        <cfargument name="OECDCatIncl" type="string" required="false" default="false">
		<cfargument name="EquityIncl" type="string" required="false" default="false">
        
    <!--- Selector Arguments --->
    	<cfargument name="ProductionTypeSelector" type="string" required="false" default="">
		<cfargument name="ProductionVolumeSelector" type="string" required="false" default="">
		<cfargument name="ProductionUnitSelector" type="string" required="false" default="">
        <cfargument name="PriceCaseSelector" type="string" required="false" default="">
        <cfargument name="Country1" type="string" required="false" default="">
        <cfargument name="Region1" type="string" required="false" default="">
        <cfargument name="Basin1" type="string" required="false" default="">
        <cfargument name="Field1" type="string" required="false" default="">
        <cfargument name="waterCatSelector" type="string" required="false" default="">
        <cfargument name="waterDepthLow" type="string" required="false" default="">
        <cfargument name="waterDepthHigh" type="string" required="false" default="">
        <cfargument name="APICatSelector" type="string" required="false" default="">
        <cfargument name="APIGravityLow" type="string" required="false" default="">
        <cfargument name="APIGravityHigh" type="string" required="false" default="">
        <cfargument name="ProjectCertaintySelector" type="string" required="false" default="">
        <cfargument name="StatusSelector" type="string" required="false" default="">
        <cfargument name="SourceRockSelector" type="string" required="false" default="">
        <cfargument name="ProductionSystemSelector" type="string" required="false" default="">
        <cfargument name="GasQualitySelector" type="string" required="false" default="">
        <cfargument name="HarshConditionSelector" type="string" required="false" default="">
        <cfargument name="ProcessingSelector" type="string" required="false" default="">
        <cfargument name="RecoveryCategorySelector" type="string" required="false" default="">
        <cfargument name="OperatedCategorySelector" type="string" required="false" default="">
        <cfargument name="OECDCategorySelector" type="string" required="false" default="">
        <cfargument name="minYear" type="string" required="false" default="2009">
        <cfargument name="maxYear" type="string" required="false" default="2030">
        <cfargument name="discountRate" type="string" required="false" default="">
		
    <!--- Company Arguments --->
    	<cfargument name="Company1" type="string" required="false" default="">
        
        
<!---Define Variables--->		
		<cfset var Production="">
        
<!---Do Search---> 
		<cfquery name="Production" datasource="myDB" result="result">
	SELECT PriceCase
   	<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, CompanyID</cfif>
   	<cfif ARGUMENTS.countryIncl IS "True">, Country</cfif>
   <cfif ARGUMENTS.regionIncl IS "True">, Region</cfif>
   <cfif ARGUMENTS.basinIncl IS "True">, Basin</cfif>
   <cfif ARGUMENTS.fieldIncl IS "True"> , Field, FieldID</cfif>
   <cfif ARGUMENTS.waterCatIncl IS "True">, WaterCat, WaterCatSortOrder</cfif>
   <cfif ARGUMENTS.waterDepthIncl IS "True">, FieldWaterDepthFt</cfif>
   <cfif ARGUMENTS.APICatIncl IS "True">, APICat, APICatSortOrder</cfif>
   <cfif ARGUMENTS.APIGravityIncl IS "True">, APIGravity</cfif>
   <cfif ARGUMENTS.maturityIncl IS "True">, ProjectCertainty, ProjectCertaintySortOrder</cfif>
   <cfif ARGUMENTS.statusIncl IS "True">, CurrentStatus</cfif>
   <cfif ARGUMENTS.sourceRockIncl IS "True">, SourceRock</cfif>
   <cfif ARGUMENTS.productionSystemIncl IS "True">, ProductionSystem</cfif>
   <cfif ARGUMENTS.gasQualityIncl IS "True">, GasQuality</cfif>
   <cfif ARGUMENTS.harshConditionIncl IS "True">, HarshCondition</cfif>
   <cfif ARGUMENTS.processingIncl IS "True">, Processing</cfif>
   <cfif ARGUMENTS.recoveryCatIncl IS "True">, RecoveryCategory</cfif>
    <cfif ARGUMENTS.operatedIncl IS "True">, Operated</cfif>
    <cfif ARGUMENTS.OECDCatIncl IS "True">, OECDCat</cfif>
	, Coalesce(Round(([1995]),4),0) AS y1995
	, Coalesce(Round(([1996]),4),0) AS y1996
	, Coalesce(Round(([1997]),4),0) AS y1997
	, Coalesce(Round(([1998]),4),0) AS y1998
	, Coalesce(Round(([1999]),4),0) AS y1999
	, Coalesce(Round(([2000]),4),0) AS y2000
	, Coalesce(Round(([2001]),4),0) AS y2001
	, Coalesce(Round(([2002]),4),0) AS y2002
	, Coalesce(Round(([2003]),4),0) AS y2003
	, Coalesce(Round(([2004]),4),0) AS y2004
	, Coalesce(Round(([2005]),4),0) AS y2005
	, Coalesce(Round(([2006]),4),0) AS y2006
	, Coalesce(Round(([2007]),4),0) AS y2007
    , Coalesce(Round(([2008]),4),0) AS y2008
	, Coalesce(Round(([2009]),4),0) AS y2009
	, Coalesce(Round(([2010]),4),0) AS y2010
	, Coalesce(Round(([2011]),4),0) AS y2011
	, Coalesce(Round(([2012]),4),0) AS y2012
	, Coalesce(Round(([2013]),4),0) AS y2013
	, Coalesce(Round(([2014]),4),0) AS y2014
	, Coalesce(Round(([2015]),4),0) AS y2015
	, Coalesce(Round(([2016]),4),0) AS y2016
	, Coalesce(Round(([2017]),4),0) AS y2017
	, Coalesce(Round(([2018]),4),0) AS y2018
	, Coalesce(Round(([2019]),4),0) AS y2019
	, Coalesce(Round(([2020]),4),0) AS y2020
	, Coalesce(Round(([2021]),4),0) AS y2021
	, Coalesce(Round(([2022]),4),0) AS y2022
	, Coalesce(Round(([2023]),4),0) AS y2023
	, Coalesce(Round(([2024]),4),0) AS y2024
	, Coalesce(Round(([2025]),4),0) AS y2025
	, Coalesce(Round(([2026]),4),0) AS y2026
	, Coalesce(Round(([2027]),4),0) AS y2027
	, Coalesce(Round(([2028]),4),0) AS y2028
	, Coalesce(Round(([2029]),4),0) AS y2029
	, Coalesce(Round(([2030]),4),0) AS y2030
 
FROM
(SELECT FieldModelResult.PriceCase
	, FieldModelResult.MYear
	<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">,	AdjustedWI.Company, AdjustedWI.CompanyID</cfif>	
    <cfif ARGUMENTS.countryIncl IS "True">, Country.Country</cfif>
    <cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
    <cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
    <cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
    <cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
    <cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
    <cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
    <cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
    <cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
    <cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status AS CurrentStatus</cfif>
    <cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
    <cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
    <cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
    <cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
    <cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
    <cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
    <cfif ARGUMENTS.operatedIncl IS "True">, CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END AS Operated</cfif>
	<cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>
    
    , <cfif ARGUMENTS.ProductionTypeSelector IS "Net Boe">ROUND(COALESCE(SUM(FieldModelResult.NetBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif>* AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Gas">ROUND(COALESCE(SUM(FieldModelResult.NetGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Oil">ROUND(COALESCE(SUM(FieldModelResult.NetOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Boe">ROUND(COALESCE(SUM(FieldModelResult.GrossBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Gas">ROUND(COALESCE(SUM(FieldModelResult.GrossGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Oil">ROUND(COALESCE(SUM(FieldModelResult.GrossOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
</cfif>
 
FROM Field 
	INNER JOIN FieldModelResult ON Field.FieldID = FieldModelResult.FieldID 
	INNER JOIN AdjustedWI ON FieldModelResult.FieldID = AdjustedWI.FieldID AND FieldModelResult.MYear = AdjustedWI.MYear
    INNER JOIN Country ON Field.CountryID = Country.CountryID 
	INNER JOIN FieldDetail ON Field.FieldID = FieldDetail.FieldID
 
WHERE
0=0
<cfif isDefined('Form.Company1')>AND (AdjustedWI.Company IN (<cfqueryparam value="#FORM.Company1#" cfsqltype="cf_sql_varchar" list="yes">))</cfif>
	
<cfif isDefined('Form.Country1')>AND Country.Country IN (<cfqueryparam value="#FORM.Country1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
 
<cfif isDefined('Form.Region1')>AND FieldDetail.Region IN (<cfqueryparam value="#FORM.Region1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
 
<cfif isDefined('Form.Basin1')>AND FieldDetail.Basin IN (<cfqueryparam value="#FORM.Basin1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
 
<cfif isDefined('Form.Field1')>AND Field.Field IN (<cfqueryparam value="#FORM.Field1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
 
<cfif NOT isDefined('FORM.EquityIncl')>AND AdjustedWI.EquitySource = 1</cfif>
 
<cfif isDefined('FORM.StatusSelector')>AND FieldModelResult.Status IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.StatusSelector#" list="yes">)</cfif>
 
AND (FieldModelResult.PriceCase = <cfqueryparam value="#ARGUMENTS.PriceCaseSelector#" cfsqltype="cf_sql_varchar">)
 
<cfif isDefined('FORM.waterCatSelector')>AND FieldDetail.WaterCatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.waterCatSelector#" list="yes">)</cfif>
 
<cfif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS NOT "">	AND (FieldDetail.FieldWaterDepthFt BETWEEN <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS "">	AND (FieldDetail.FieldWaterDepthFT >= <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.waterDepthLow IS "" AND ARGUMENTS.waterDepthHigh IS NOT ""> AND (FieldDetail.FieldWaterDepthFt <= <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_integer">)
</cfif>
 
<cfif isDefined('FORM.APICatSelector')>AND FieldDetail.APICatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.APICatSelector#" list="yes">)</cfif>
 
<cfif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS NOT "">	AND (FieldDetail.APIGravity BETWEEN <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS "">	AND (FieldDetail.APIGravity >= <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.APIGravityLow IS "" AND ARGUMENTS.APIGravityHigh IS NOT ""> AND (FieldDetail.APIGravity <= <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_integer">)
</cfif>
 
<cfif isDefined('FORM.ProjectCertaintySelector')>AND FieldDetail.ProjectCertaintyID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProjectCertaintySelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.SourceRockSelector')>AND FieldDetail.SourceRockID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.SourceRockSelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.ProductionSystemSelector')>AND FieldDetail.ProductionSystemID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProductionSystemSelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.GasQualitySelector')>AND FieldDetail.GasQualityID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.GasQualitySelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.HarshConditionSelector')>AND FieldDetail.HarshConditionID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.HarshConditionSelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.ProcessingSelector')>AND FieldDetail.ProcessingID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProcessingSelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.RecoveryCategorySelector')>AND FieldDetail.RecoveryCategoryID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.RecoveryCategorySelector#" list="yes">)</cfif>
 
<cfif isDefined('FORM.OperatedCategorySelector')>
<cfif listLen(FORM.OperatedCategorySelector) EQ 3>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) LIKE '%')
</cfif>
<cfif listLen(FORM.OperatedCategorySelector) EQ 2>		
<cfif listContainsNoCase(FORM.OperatedCategorySelector,1) AND listContainsNoCase(FORM.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,1) AND listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Unknown')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,2) AND listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Non-Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>																																																									
<cfif listLen(FORM.OperatedCategorySelector) EQ 1>
<cfif listContainsNoCase(FORM.OperatedCategorySelector,1)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>
</cfif>
 
<cfif isDefined('FORM.OECDCategorySelector')>AND FieldDetail.OECDCatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.OECDCategorySelector#" list="yes">)</cfif>
 
 AND (FieldModelResult.MYear BETWEEN <cfqueryparam value="#FORM.minYear#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#FORM.maxYear#" cfsqltype="cf_sql_integer">)
 
GROUP BY FieldModelResult.PriceCase
	, FieldModelResult.MYear
    <cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, AdjustedWI.CompanyID</cfif>	
   <cfif ARGUMENTS.countryIncl IS NOT "">, Country.Country</cfif>
   <cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
    <cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
    <cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
    <cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
    <cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
    <cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
    <cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
    <cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
    <cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status</cfif>
    <cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
    <cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
    <cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
    <cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
    <cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
    <cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
    <cfif ARGUMENTS.operatedIncl IS "True">, FieldDetail.Operator</cfif>
    <cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>) q1
PIVOT
(SUM(ProductionData) FOR q1.MYear IN
([1995],[1996],[1997],[1998],[1999],[2000],[2001],[2002],[2003],[2004],[2005],[2006],[2007],[2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020],[2021],[2022],[2023],[2024],[2025],[2026],[2027],[2028],[2029],[2030])) AS pvt
 
            
            <cfif gridsortcolumn neq ''>
        order by #gridsortcolumn# #gridsortdirection#
        </cfif>
			
</cfquery>
		
		
			
        <cfreturn queryconvertforgrid(Production,page,pagesize)/>
        
	</cffunction>
 
 
 
 
---CFM---
 
<div style="width:1000px; clear:both;" align="center">
     
     <cfoutput>
	<cfform name="tableform">
 
    <cfgrid format="html" name="grid_Tables" pagesize="25" selectmode="row"
bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
                        
                        
                        <cfif isDefined('Form.Company1') OR isDefined('FORM.companyIncl')><cfgridcolumn name="Company" header="Company"></cfif>
                        <cfif isDefined('FORM.countryIncl')><cfgridcolumn name="Country" header="Country"></cfif>
                        <cfif isDefined('FORM.regionIncl')><cfgridcolumn name="Region" header="Region"></cfif>
                        <cfif isDefined('FORM.basinIncl')><cfgridcolumn name="Basin" header="Basin"></cfif>
                        <cfif isDefined('FORM.OECDCatIncl')><cfgridcolumn name="OECDCat" header="OECD Category"></cfif>
                        <cfif isDefined('FORM.fieldIncl')><cfgridcolumn name="Field" header="Field"></cfif>
                        <cfif isDefined('FORM.operatedIncl')><cfgridcolumn name="Operated" header="Operated Category"></cfif>
                        <cfif isDefined('FORM.waterCatIncl')><cfgridcolumn name="WaterCat" header="Water Depth Category"></cfif>
                        <cfif isDefined('FORM.waterDepthIncl')><cfgridcolumn name="FieldWaterDepthFt" header="Water Depth (Ft)"></cfif>
                        <cfif isDefined('FORM.APICatIncl')><cfgridcolumn name="APICat" header="API Category"></cfif>
                        <cfif isDefined('FORM.APIGravityIncl')><cfgridcolumn name="APIGravity" header="API Gravity"></cfif>
                        <cfif isDefined('FORM.maturityIncl')><cfgridcolumn name="ProjectCertainty" header="Project Maturity"></cfif>
                        <cfif isDefined('FORM.statusIncl')><cfgridcolumn name="CurrentStatus" header="Status"></cfif>
                        <cfif isDefined('FORM.sourceRockIncl')><cfgridcolumn name="SourceRock" header="Source Rock"></cfif>
                        <cfif isDefined('FORM.productionSystemIncl')><cfgridcolumn name="ProductionSystem" header="Production System"></cfif>
                        <cfif isDefined('FORM.gasQualityIncl')><cfgridcolumn name="GasQuality" header="Gas Quality"></cfif>
                        <cfif isDefined('FORM.harshConditionIncl')><cfgridcolumn name="HarshCondition" header="Harsh Conditions"></cfif>
                        <cfif isDefined('FORM.processingIncl')><cfgridcolumn name="Processing" header="Processing"></cfif>
                        <cfif isDefined('FORM.recoveryCatIncl')><cfgridcolumn name="RecoveryCategory" header="Recovery Category"></cfif>
                        <cfif 1995 GTE #FORM.minYear# AND 1995 LTE #FORM.maxYear#><cfgridcolumn name="y1995" header="1995"></cfif>
                        <cfif 1996 GTE #FORM.minYear# AND 1996 LTE #FORM.maxYear#><cfgridcolumn name="y1996" header="1996"></cfif>
                        <cfif 1997 GTE #FORM.minYear# AND 1997 LTE #FORM.maxYear#><cfgridcolumn name="y1997" header="1997"></cfif>
                        <cfif 1998 GTE #FORM.minYear# AND 1998 LTE #FORM.maxYear#><cfgridcolumn name="y1998" header="1998"></cfif>
                        <cfif 1999 GTE #FORM.minYear# AND 1999 LTE #FORM.maxYear#><cfgridcolumn name="y1999" header="1999"></cfif>
                        <cfif 2000 GTE #FORM.minYear# AND 2000 LTE #FORM.maxYear#><cfgridcolumn name="y2000" header="2000"></cfif>
                        <cfif 2001 GTE #FORM.minYear# AND 2001 LTE #FORM.maxYear#><cfgridcolumn name="y2001" header="2001"></cfif>
                        <cfif 2002 GTE #FORM.minYear# AND 2002 LTE #FORM.maxYear#><cfgridcolumn name="y2002" header="2002"></cfif>
                        <cfif 2003 GTE #FORM.minYear# AND 2003 LTE #FORM.maxYear#><cfgridcolumn name="y2003" header="2003"></cfif>
                        <cfif 2004 GTE #FORM.minYear# AND 2004 LTE #FORM.maxYear#><cfgridcolumn name="y2004" header="2004"></cfif>
                        <cfif 2005 GTE #FORM.minYear# AND 2005 LTE #FORM.maxYear#><cfgridcolumn name="y2005" header="2005"></cfif>
                        <cfif 2006 GTE #FORM.minYear# AND 2006 LTE #FORM.maxYear#><cfgridcolumn name="y2006" header="2006"></cfif>
                        <cfif 2007 GTE #FORM.minYear# AND 2007 LTE #FORM.maxYear#><cfgridcolumn name="y2007" header="2007"></cfif>
						<cfif 2008 GTE #FORM.minYear# AND 2008 LTE #FORM.maxYear#><cfgridcolumn name="y2008" header="2008"></cfif>
                        <cfif 2009 GTE #FORM.minYear# AND 2009 LTE #FORM.maxYear#><cfgridcolumn name="y2009" header="2009"></cfif>
                        <cfif 2010 GTE #FORM.minYear# AND 2010 LTE #FORM.maxYear#><cfgridcolumn name="y2010" header="2010"></cfif>
                        <cfif 2011 GTE #FORM.minYear# AND 2011 LTE #FORM.maxYear#><cfgridcolumn name="y2011" header="2011"></cfif>
                        <cfif 2012 GTE #FORM.minYear# AND 2012 LTE #FORM.maxYear#><cfgridcolumn name="y2012" header="2012"></cfif>
                        <cfif 2013 GTE #FORM.minYear# AND 2013 LTE #FORM.maxYear#><cfgridcolumn name="y2013" header="2013"></cfif>
                        <cfif 2014 GTE #FORM.minYear# AND 2014 LTE #FORM.maxYear#><cfgridcolumn name="y2014" header="2014"></cfif>
                        <cfif 2015 GTE #FORM.minYear# AND 2015 LTE #FORM.maxYear#><cfgridcolumn name="y2015" header="2015"></cfif>
                        <cfif 2016 GTE #FORM.minYear# AND 2016 LTE #FORM.maxYear#><cfgridcolumn name="y2016" header="2016"></cfif>
                        <cfif 2017 GTE #FORM.minYear# AND 2017 LTE #FORM.maxYear#><cfgridcolumn name="y2017" header="2017"></cfif>
                        <cfif 2018 GTE #FORM.minYear# AND 2018 LTE #FORM.maxYear#><cfgridcolumn name="y2018" header="2018"></cfif>
                        <cfif 2019 GTE #FORM.minYear# AND 2019 LTE #FORM.maxYear#><cfgridcolumn name="y2019" header="2019"></cfif>
                        <cfif 2020 GTE #FORM.minYear# AND 2020 LTE #FORM.maxYear#><cfgridcolumn name="y2020" header="2020"></cfif>
                        <cfif 2021 GTE #FORM.minYear# AND 2021 LTE #FORM.maxYear#><cfgridcolumn name="y2021" header="2021"></cfif>
                        <cfif 2022 GTE #FORM.minYear# AND 2022 LTE #FORM.maxYear#><cfgridcolumn name="y2022" header="2022"></cfif>
                        <cfif 2023 GTE #FORM.minYear# AND 2023 LTE #FORM.maxYear#><cfgridcolumn name="y2023" header="2023"></cfif>
                        <cfif 2024 GTE #FORM.minYear# AND 2024 LTE #FORM.maxYear#><cfgridcolumn name="y2024" header="2024"></cfif>
                        <cfif 2025 GTE #FORM.minYear# AND 2025 LTE #FORM.maxYear#><cfgridcolumn name="y2025" header="2025"></cfif>
                        <cfif 2026 GTE #FORM.minYear# AND 2026 LTE #FORM.maxYear#><cfgridcolumn name="y2026" header="2026"></cfif>
                        <cfif 2027 GTE #FORM.minYear# AND 2027 LTE #FORM.maxYear#><cfgridcolumn name="y2027" header="2027"></cfif>
                        <cfif 2028 GTE #FORM.minYear# AND 2028 LTE #FORM.maxYear#><cfgridcolumn name="y2028" header="2028"></cfif>
                        <cfif 2029 GTE #FORM.minYear# AND 2029 LTE #FORM.maxYear#><cfgridcolumn name="y2029" header="2029"></cfif>
                        <cfif 2030 GTE #FORM.minYear# AND 2030 LTE #FORM.maxYear#><cfgridcolumn name="y2030" header="2030"></cfif>
                        
                        
    </cfgrid>
</cfform>
</cfoutput>
     
    
                    	
                           
            
            </div>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:

Select all Open in new window

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Plus...

30 Day FREE access, no risk, no obligation
Collaborate with the world's top tech experts
Unlimited access to our exclusive solution database
Never be left without tech help again

Subscribe Now

Asked On: 2009-10-18 at 23:36:03ID24822701
Tags: Coldfusion
,; Binding
,; CFGRID
Topics: Cold Fusion Markup Language
,; ColdFusion Application Server
Participating Experts: 2
Points: 500
Comments: 19

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

"The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
"Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
"Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Free Tech Articles

WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Watch More

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

by: azadisaryevPosted on 2009-10-18 at 23:58:48ID: 25603017

do not put your additional arguments in curvy braces. just pass then as is, e.g:

bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, companyIncl)"

iirc, you need to use curvy braces only if you are passing a reference to another form field and/or a built-in parameter like for example cfgridpage.

one thing to keep in mind: you can't pass a comma-delimited list as argument. you must change list delimiters to something else (i.e. | a pipe character) or the binding will fail. use listchangedelims() cf function if you need to change listdelimiters.

Azadi

by: av8or16Posted on 2009-10-19 at 00:16:26ID: 25603080

Hi Azadi,

I tried doing it the way you suggested, but I receive the firebug error message I described in my original question (the long error message).

When I tried it this way the full bind for all the arguments is...

<cfgrid format="html" name="grid_Tables" pagesize="25" selectmode="row"
bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, companyIncl, countryIncl, regionIncl, basinIncl, fieldIncl, waterCatIncl, waterDepthIncl, APICatIncl, APIGravityIncl, maturityIncl, statusIncl, sourceRockIncl, productionSystemIncl, gasQualityIncl, harshConditionIncl, processingIncl, recoveryCatIncl, operatedIncl, OECDCatIncl, EquityIncl, ProductionTypeSelector, ProductionVolumeSelector, ProductionUnitSelector, PriceCaseSelector, Country1, Region1, Basin1, Field1, waterCatSelector, waterDepthLow, waterDepthHigh, APICatSelector, APIGravityLow, APIGravityHigh, ProjectCertaintySelector, StatusSelector, SourceRockSelector, ProductionSystemSelector, GasQualitySelector, HarshConditionSelector, ProcessingSelector, RecoveryCategorySelector, OperatedCategorySelector, OECDCategorySelector, minYear, maxYear, discountRate, Company1)">

by: azadisaryevPosted on 2009-10-19 at 02:36:22ID: 25603698

ok, i somehow missed that you have tried that already, sorry.

where are all the vars you are passing to the binding coming from?
are you sure they all exist/are defined on first page load when your cfgrid gets rendered?
if these vars are user-defined via a from, and your cfgrid is on the same page as this form, then unless you <cfparam> these vars they will not exist when the page first loads.

also, have you use cf ajax debugger to see if it gives you a better error message than firebug?
enable ajax debugging in cf admin and add ?cfdebug to the url of your page to see the debugger popup.

a viewable example of your page may also help...

Azadi

by: pravinasarPosted on 2009-10-19 at 10:13:53ID: 25607031

No points necessary, as I am referring to one of my earlier solution

Look the

http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_24726783.html

This explains, how bind works with ColdFusion Grid (cfgrid)

by: av8or16Posted on 2009-10-19 at 13:47:55ID: 25608868

Azadi,

The vars being passed to the binding are user defined inputs from a form. I am using coldfusion.navigate to return the results. Everything works fine in table format where I can use argumentcollection --

<cfinvoke component="cfc/Production">
method="getProduction2"
returnvariable="qResults"
argumentcollection="#FORM#">

I changed the bind to:

bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, #companyIncl#, #countryIncl#, #regionIncl#, #basinIncl#, #fieldIncl#, #waterCatIncl#, #waterDepthIncl#, #APICatIncl#, #APIGravityIncl#, #maturityIncl#, #statusIncl#, #sourceRockIncl#, #productionSystemIncl#, #gasQualityIncl#, #harshConditionIncl#, #processingIncl#, #recoveryCatIncl#, #operatedIncl#, #OECDCatIncl#, #EquityIncl#, '#ProductionTypeSelector#', '#ProductionVolumeSelector#', '#ProductionUnitSelector#', '#PriceCaseSelector#', '#Country1#', '#Region1#, #Basin1#, #Field1#, #waterCatSelector#, #waterDepthLow#, #waterDepthHigh#, #APICatSelector#, #APIGravityLow#, #APIGravityHigh#, #ProjectCertaintySelector#, #StatusSelector#, #SourceRockSelector#, #ProductionSystemSelector#, #GasQualitySelector#, #HarshConditionSelector#, #ProcessingSelector#, #RecoveryCategorySelector#, #OperatedCategorySelector#, #OECDCategorySelector#, #minYear#, #maxYear#, #discountRate#, #Company1#)">

I added cfparams to the cfm page calling the cfc and that got rid of the error message saying that one or more of my form variables were not defined.

However, the new problem is that the form contains selects that allow multiples. When I run the query now, I receive an error message stating 'You cannot specify more arguments to a CFC function than it declares.'

Any ideas on how to pass the multiple selects as a single argument instead of each item in the comma separated list being treated as a separate argument?

You can view the form at http://testing.gordonenergysolutions.com/gridtest.cfm</cfinvoke>

by: azadisaryevPosted on 2009-10-19 at 20:15:10ID: 25610824

>> Any ideas on how to pass the multiple selects as a single argument instead of each item in the comma separated list being treated as a separate argument?

that's exactly what i was talking about when i said you can't pass comma-delimited lists as bind arguments in my first answer.
you will need to change list delimiters to something else, like a | (pipe), using listchangedelims() function.
for example, if your #APICatSelector# was a comma-delimited list of selected items in a multi-select, then you would pass it as:
bind="cfc:cfc.Production.getProduction2(..., #listchangedelims(APICatSelector, "|", ",")#, ...)"

note that - and this is something i somehow forgot to mention before - if the variable you pass as bind argument is a string type, you need to enclose it in single quotes. so if APICatSelector var held a list of text strings, then you would use it as '#listchangedelims(APICatSelector, "|", ",")#'

Azadi

by: azadisaryevPosted on 2009-10-19 at 20:23:32ID: 25610841

important correction:

ANY list you pass as bind parameter should be enclosed in quotation marks. not just text lists, but numeric lists as well.

Azadi

by: av8or16Posted on 2009-10-19 at 21:50:42ID: 25611142

Azadi,

I have come across another problem with this implementation. Your solution solved the issue of passing the additional arguments in the bind.

However, now I receive an error message stating

'Error invoking CFC /data/production/Production.cfc : Not Found [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]'

The cfc is located in the same folder as the cfm file calling it.

I know the path is correct because I changed the access type of the cfc function from 'remote' to 'public' and got an error message stating

'Error retrieving markup for element resultdiv : The specified function getProductions on the CFC Production must have its access attribute set to 'remote'. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]'

I already awarded the points, but would appreciate any further guidance you could give.

by: azadisaryevPosted on 2009-10-19 at 22:19:54ID: 25611208

1) the path to cfc should be a dot-delimited path, not slash-delimited as in folder paths
2) if you cfc is in the same folder as calling page, you do not need to specify any path - just the cfc name - as that's the first place cfc will look for your cfc. so if the Production.cfc is in same folder as your page, the path in the bind attribute should be: bind="cfc:Production.getProduction2(...)"

Azadi

by: av8or16Posted on 2009-10-19 at 22:22:34ID: 25611211

That's exactly how I have it setup, yet I am still receiving the error message. I also know it's not a mapping issue because other grid bindings are working just fine.

by: azadisaryevPosted on 2009-10-19 at 22:52:48ID: 25611305

do you have a cf mapping set up in cf admin (or in your Application.cfc) for the directory where the cfc is in?
can you post what your mapping setup is?

also, can you post the bind attribute exactly as you have it now?
(in your previous post you had it as 'bind="cfc:cfc.Production.getProduction2(...)', i suggested you drop the 'cfc.' part, but you say it is still not working? then, where does the data/production/... path come in from?)

Azadi

by: av8or16Posted on 2009-10-19 at 23:05:14ID: 25611348

The mapping I referred to was mapping CFIDE to my IIS site. The disk root of my site is C:\sites\testing.

The form that is submitted is at this level -- ie. c:\sites\testing\coreanalysis.cfm.

The cfm page that is called is at c:\sites\testing\data\production\production2.cfm.

I moved the cfc to the same root -- ie. c:\sites\data\production\production.cfc.

The bind is now:

<cfgrid format="html" name="grid_Tables" pagesize="25" selectmode="row">
bind="cfc:Production.getProduction2({cfgridpage}
,{cfgridpagesize}
,{cfgridsortcolumn}
,{cfgridsortdirection}
, '#companyIncl#'
, '#countryIncl#'
, '#regionIncl#'
, '#basinIncl#'
, '#fieldIncl#'
, '#waterCatIncl#'
, '#waterDepthIncl#'
, '#APICatIncl#'
, '#APIGravityIncl#'
, '#maturityIncl#'
, '#statusIncl#'
, '#sourceRockIncl#'
, '#productionSystemIncl#'
, '#gasQualityIncl#'
, '#harshConditionIncl#'
, '#processingIncl#'
, '#recoveryCatIncl#'
, '#operatedIncl#'
, '#OECDCatIncl#'
, '#EquityIncl#'
, '#listchangedelims(ProductionTypeSelector, "|", ",")#'
, '#ProductionVolumeSelector#'
, '#ProductionUnitSelector#'
, '#PriceCaseSelector#'
, '#listchangedelims(Country1, "|", ",")#'
, '#listchangedelims(Region1, "|", ",")#'
, '#listchangedelims(Basin1, "|", ",")#'
, '#listchangedelims(Field1, "|", ",")#'
, '#listchangedelims(waterCatSelector, "|", ",")#'
, '#waterDepthLow#'
, '#waterDepthHigh#'
, '#listchangedelims(APICatSelector, "|", ",")#'
, '#APIGravityLow#'
, '#APIGravityHigh#'
, '#listchangedelims(ProjectCertaintySelector, "|", ",")#'
, '#listchangedelims(StatusSelector, "|", ",")#'
, '#listchangedelims(SourceRockSelector, "|", ",")#'
, '#listchangedelims(ProductionSystemSelector, "|", ",")#'
, '#listchangedelims(GasQualitySelector, "|", ",")#'
, '#listchangedelims(HarshConditionSelector, "|", ",")#'
, '#listchangedelims(ProcessingSelector, "|", ",")#'
, '#listchangedelims(RecoveryCategorySelector, "|", ",")#'
, '#listchangedelims(OperatedCategorySelector, "|", ",")#'
, '#listchangedelims(OECDCategorySelector, "|", ",")#'
, '#minYear#'
, '#maxYear#'
, '#discountRate#'
, '#listchangedelims(Company1, "|", ",")#')">

In Production.cfc, I also changed the separator in cfqueryparam to "|" to correspond to the new delimims.</cfgrid>

by: azadisaryevPosted on 2009-10-19 at 23:37:17ID: 25611465

and which page is the cfgrid in - coreanalysis.cfm or production2.cfm?

>> I moved the cfc to the same root -- ie. c:\sites\data\production\production.cfc.

is that really the cfc path, or did you just forget to include 'testing/' folder there?

Azadic

by: av8or16Posted on 2009-10-19 at 23:42:09ID: 25611496

the cfgrid is in production2.cfm

Sorry... forgot to include testing

Both production2.cfm & Production.cfc are in the same folder -- c:\sites\testing\data\production

Happy to open a new question so you can get points for all the extra time your putting in on this.

by: azadisaryevPosted on 2009-10-19 at 23:47:10ID: 25611526

hmm... maybe it's getting confused with your folder and cfc having the same name (production)?

try renaming your cfc to something different - like Productioncfc.cfc - and changing the binding accordingly (bind="cfc:Productioncfc.getProduction2...).

Azadi

by: av8or16Posted on 2009-10-20 at 00:11:42ID: 25611623

No Go.

I tried that and got the same error.

I can't figure it out since another cfm page in the same folder is able to call Production.cfc and generate a grid without a problem. This particular grid does not have any additional arguments other than those required for cfgrid.

Like I said in an earlier comment, I changed the access type of the function and it had no problem finding the cfc.

I received this error message

'Error retrieving markup for element resultdiv : The specified function getProduction2 on the CFC Production must have its access attribute set to 'remote'. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]'

I'm stumped.

The CF Ajax Logger contained this:

error:http: Error invoking CFC /data/production/Prodcfc.cfc : Not Found

info:widget: Created grid, id: grid_Tables

info:http: HTTP GET /data/production/Prodcfc.cfc?method=getProductionGrid&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A25%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%2C%22companyIncl%22%3A%22true%22%2C%22countryIncl%22%3A%22true%22%2C%22regionIncl%22%3A%22%22%2C%22basinIncl%22%3A%22%22%2C%22fieldIncl%22%3A%22true%22%2C%22waterCatIncl%22%3A%22%22%2C%22waterDepthIncl%22%3A%22%22%2C%22APICatIncl%22%3A%22%22%2C%22APIGravityIncl%22%3A%22%22%2C%22maturityIncl%22%3A%22%22%2C%22statusIncl%22%3A%22%22%2C%22sourceRockIncl%22%3A%22%22%2C%22productionSystemIncl%22%3A%22%22%2C%22gasQualityIncl%22%3A%22%22%2C%22harshConditionIncl%22%3A%22%22%2C%22processingIncl%22%3A%22%22%2C%22recoveryCatIncl%22%3A%22%22%2C%22operatedIncl%22%3A%22%22%2C%22OECDCatIncl%22%3A%22%22%2C%22EquityIncl%22%3A%22%22%2C%22ProductionTypeSelector%22%3A%22Net%20Boe%22%2C%22ProductionVolumeSelector%22%3A%221%22%2C%22ProductionUnitSelector%22%3A%221%22%2C%22PriceCaseSelector%22%3A%22%2470%22%2C%22Country1%22%3A%22%22%2C%22Region1%22%3A%22%22%2C%22Basin1%22%3A%22%22%2C%22Field1%22%3A%22%22%2C%22waterCatSelector%22%3A%222%7C3%7C4%7C5%7C6%22%2C%22waterDepthLow%22%3A%22%22%2C%22waterDepthHigh%22%3A%22%22%2C%22APICatSelector%22%3A%222%7C3%7C4%7C5%7C6%22%2C%22APIGravityLow%22%3A%22%22%2C%22APIGravityHigh%22%3A%22%22%2C%22ProjectCertaintySelector%22%3A%221%7C2%7C3%7C4%7C5%7C10%7C7%7C8%7C6%22%2C%22StatusSelector%22%3A%22Legacy%7CNew%22%2C%22SourceRockSelector%22%3A%223%7C6%7C7%7C5%7C2%7C1%7C8%7C12%7C9%7C4%7C11%22%2C%22ProductionSystemSelector%22%3A%2210%7C6%7C13%7C2%7C3%7C14%7C12%7C8%7C9%7C4%7C7%7C11%7C5%7C1%7C16%22%2C%22GasQualitySelector%22%3A%222%7C1%7C4%22%2C%22HarshConditionSelector%22%3A%221%7C3%22%2C%22ProcessingSelector%22%3A%223%7C2%7C1%7C5%22%2C%22RecoveryCategorySelector%22%3A%2210%7C12%7C1%7C14%7C8%7C15%7C18%7C5%7C4%7C9%7C13%7C11%7C17%22%2C%22OperatedCategorySelector%22%3A%221%7C2%7C3%22%2C%22OECDCategorySelector%22%3A%222%7C3%22%2C%22minYear%22%3A%222009%22%2C%22maxYear%22%3A%222030%22%2C%22discountRate%22%3A%2210%22%2C%22Company1%22%3A%22%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=61A0EF0016B8BAA16BDC045B4C4230D2&_cf_rc=0

info:http: Invoking CFC: /data/production/Prodcfc.cfc , function: getProductionGrid , arguments: {"page":1,"pageSize":25,"gridsortcolumn":"","gridsortdirection":"","companyIncl":"true","countryIncl":"true","regionIncl":"","basinIncl":"","fieldIncl":"true","waterCatIncl":"","waterDepthIncl":"","APICatIncl":"","APIGravityIncl":"","maturityIncl":"","statusIncl":"","sourceRockIncl":"","productionSystemIncl":"","gasQualityIncl":"","harshConditionIncl":"","processingIncl":"","recoveryCatIncl":"","operatedIncl":"","OECDCatIncl":"","EquityIncl":"","ProductionTypeSelector":"Net Boe","ProductionVolumeSelector":"1","ProductionUnitSelector":"1","PriceCaseSelector":"$70","Country1":"","Region1":"","Basin1":"","Field1":"","waterCatSelector":"2|3|4|5|6","waterDepthLow":"","waterDepthHigh":"","APICatSelector":"2|3|4|5|6","APIGravityLow":"","APIGravityHigh":"","ProjectCertaintySelector":"1|2|3|4|5|10|7|8|6","StatusSelector":"Legacy|New","SourceRockSelector":"3|6|7|5|2|1|8|12|9|4|11","ProductionSystemSelector":"10|6|13|2|3|14|12|8|9|4|7|11|5|1|16","GasQualitySelector":"2|1|4","HarshConditionSelector":"1|3","ProcessingSelector":"3|2|1|5","RecoveryCategorySelector":"10|12|1|14|8|15|18|5|4|9|13|11|17","OperatedCategorySelector":"1|2|3","OECDCategorySelector":"2|3","minYear":"2009","maxYear":"2030","discountRate":"10","Company1":""}

info:LogReader: LogReader initialized

info:global: Logger initialized

by: azadisaryevPosted on 2009-10-20 at 00:51:19ID: 25611777

hmm... this is very strange...

one more thing to check:
is the folder the cfc is in under your physical web root or in a virtual directory? i.e. is data/production/ a physical folder under c:/sites/testing or is it (or part of it) a virtual dir set up in IIS? is testing/ a virtual directory?

cfc's must be under physical web root to work...

hmm... but then you say another cfgrid binds to that same cfc without a problem?

maybe the url resulting from cfc function invocation is too long? i do not recall ever hearing this as a problem, but who knows... try requesting the cfc directly in your browser with this shorter url:
http://yourdomain.com/data/production/Prodcfc.cfc?method=getProductionGrid&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A25%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%2C%22companyIncl%22%3A%22true%22%2C%22countryIncl%22%3A%22true%22%2C%22regionIncl%22%3A%22%22%2C%22basinIncl%22%3A%22%22%2C%22fieldIncl%22%3A%22true%22%2C%22waterCatIncl%22%3A%22%22%2C%22waterDepthIncl%22%3A%22%22%2C%22APICatIncl%22%3A%22%22%2C%22APIGravityIncl%22%3A%22%22%2C%22maturityIncl%22%3A%22%22%2C%22statusIncl%22%3A%22%22%2C%22sourceRockIncl%22%3A%22%22%2C%22productionSystemIncl%22%3A%22%22%7D

(replace yourdomain.com with your actual domain name)

if all else fails - restart your cf server and see if that helps.
i will keep digging at this meanwhile...

Azadi

by: av8or16Posted on 2009-10-20 at 10:40:31ID: 25616540

I know the url is not too long, because I ran into that error last night. I had missed quotations around a string variable and it returned NULL 20-30 times which caused the error. It no longer does this.

I tried requesting the cfc directly as you suggested above.

I now recieve

500 - Internal server error.

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'FROM'.

The error occurred in C:\sites\testing\data\production\Prodcfc.cfc: line 279

277 :
278 : <cfif gridsortcolumn="" neq="">
279 : order by #gridsortcolumn# #gridsortdirection#
280 : </cfif>
281 :

I can't see why this would occur because the query works just fine in other instances. The only thing I changed in the CFC from its original form was the separator in cfqueryparam.

<!---  --->
	<cffunction name="getProductionGrid" access="remote" returntype="any">
    
   		<cfargument name="page" required="yes" type="numeric">
        <cfargument name="pageSize" required="yes" type="numeric">
        <cfargument name="gridsortcolumn" required="no" type="string">
        <cfargument name="gridsortdirection" required="no" type="string">
  <!--- Include/Exclude Arguments --->
		<cfargument name="companyIncl" type="string" required="false" default="false">
        <cfargument name="countryIncl" type="string" required="false" default="false">
        <cfargument name="regionIncl" type="string" required="false" default="false">
        <cfargument name="basinIncl" type="string" required="false" default="false">
        <cfargument name="fieldIncl" type="string" required="false" default="false">
        <cfargument name="waterCatIncl" type="string" required="false" default="false">
        <cfargument name="waterDepthIncl" type="string" required="false" default="false">
        <cfargument name="APICatIncl" type="string" required="false" default="false">
        <cfargument name="APIGravityIncl" type="string" required="false" default="false">
        <cfargument name="maturityIncl" type="string" required="false" default="false">
        <cfargument name="statusIncl" type="string" required="false" default="false">
        <cfargument name="sourceRockIncl" type="string" required="false" default="false">
        <cfargument name="productionSystemIncl" type="string" required="false" default="false">
        <cfargument name="gasQualityIncl" type="string" required="false" default="false">
        <cfargument name="harshConditionIncl" type="string" required="false" default="false">
        <cfargument name="processingIncl" type="string" required="false" default="false">
        <cfargument name="recoveryCatIncl" type="string" required="false" default="false">
        <cfargument name="operatedIncl" type="string" required="false" default="false">
        <cfargument name="OECDCatIncl" type="string" required="false" default="false">
		<cfargument name="EquityIncl" type="string" required="false" default="false">
        
    <!--- Selector Arguments --->
    	<cfargument name="ProductionTypeSelector" type="string" required="false" default="">
		<cfargument name="ProductionVolumeSelector" type="string" required="false" default="">
		<cfargument name="ProductionUnitSelector" type="string" required="false" default="">
        <cfargument name="PriceCaseSelector" type="string" required="false" default="">
        <cfargument name="Country1" type="string" required="false" default="">
        <cfargument name="Region1" type="string" required="false" default="">
        <cfargument name="Basin1" type="string" required="false" default="">
        <cfargument name="Field1" type="string" required="false" default="">
        <cfargument name="waterCatSelector" type="string" required="false" default="">
        <cfargument name="waterDepthLow" type="string" required="false" default="">
        <cfargument name="waterDepthHigh" type="string" required="false" default="">
        <cfargument name="APICatSelector" type="string" required="false" default="">
        <cfargument name="APIGravityLow" type="string" required="false" default="">
        <cfargument name="APIGravityHigh" type="string" required="false" default="">
        <cfargument name="ProjectCertaintySelector" type="string" required="false" default="">
        <cfargument name="StatusSelector" type="string" required="false" default="">
        <cfargument name="SourceRockSelector" type="string" required="false" default="">
        <cfargument name="ProductionSystemSelector" type="string" required="false" default="">
        <cfargument name="GasQualitySelector" type="string" required="false" default="">
        <cfargument name="HarshConditionSelector" type="string" required="false" default="">
        <cfargument name="ProcessingSelector" type="string" required="false" default="">
        <cfargument name="RecoveryCategorySelector" type="string" required="false" default="">
        <cfargument name="OperatedCategorySelector" type="string" required="false" default="">
        <cfargument name="OECDCategorySelector" type="string" required="false" default="">
        <cfargument name="minYear" type="string" required="false" default="2009">
        <cfargument name="maxYear" type="string" required="false" default="2030">
        <cfargument name="discountRate" type="string" required="false" default="">
		
    <!--- Company Arguments --->
    	<cfargument name="Company1" type="string" required="false" default="">
        
        
<!---Define Variables--->		
		<cfset var Production="">
        
<!---Do Search---> 
		<cfquery name="Production" datasource="GESLive" result="result">
	SELECT PriceCase
   	<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, CompanyID</cfif>
   	<cfif ARGUMENTS.countryIncl IS "True">, Country</cfif>
   <cfif ARGUMENTS.regionIncl IS "True">, Region</cfif>
   <cfif ARGUMENTS.basinIncl IS "True">, Basin</cfif>
   <cfif ARGUMENTS.fieldIncl IS "True"> , Field, FieldID</cfif>
   <cfif ARGUMENTS.waterCatIncl IS "True">, WaterCat, WaterCatSortOrder</cfif>
   <cfif ARGUMENTS.waterDepthIncl IS "True">, FieldWaterDepthFt</cfif>
   <cfif ARGUMENTS.APICatIncl IS "True">, APICat, APICatSortOrder</cfif>
   <cfif ARGUMENTS.APIGravityIncl IS "True">, APIGravity</cfif>
   <cfif ARGUMENTS.maturityIncl IS "True">, ProjectCertainty, ProjectCertaintySortOrder</cfif>
   <cfif ARGUMENTS.statusIncl IS "True">, CurrentStatus</cfif>
   <cfif ARGUMENTS.sourceRockIncl IS "True">, SourceRock</cfif>
   <cfif ARGUMENTS.productionSystemIncl IS "True">, ProductionSystem</cfif>
   <cfif ARGUMENTS.gasQualityIncl IS "True">, GasQuality</cfif>
   <cfif ARGUMENTS.harshConditionIncl IS "True">, HarshCondition</cfif>
   <cfif ARGUMENTS.processingIncl IS "True">, Processing</cfif>
   <cfif ARGUMENTS.recoveryCatIncl IS "True">, RecoveryCategory</cfif>
    <cfif ARGUMENTS.operatedIncl IS "True">, Operated</cfif>
    <cfif ARGUMENTS.OECDCatIncl IS "True">, OECDCat</cfif>
	, Coalesce(Round(([1995]),4),0) AS y1995
	, Coalesce(Round(([1996]),4),0) AS y1996
	, Coalesce(Round(([1997]),4),0) AS y1997
	, Coalesce(Round(([1998]),4),0) AS y1998
	, Coalesce(Round(([1999]),4),0) AS y1999
	, Coalesce(Round(([2000]),4),0) AS y2000
	, Coalesce(Round(([2001]),4),0) AS y2001
	, Coalesce(Round(([2002]),4),0) AS y2002
	, Coalesce(Round(([2003]),4),0) AS y2003
	, Coalesce(Round(([2004]),4),0) AS y2004
	, Coalesce(Round(([2005]),4),0) AS y2005
	, Coalesce(Round(([2006]),4),0) AS y2006
	, Coalesce(Round(([2007]),4),0) AS y2007
    , Coalesce(Round(([2008]),4),0) AS y2008
	, Coalesce(Round(([2009]),4),0) AS y2009
	, Coalesce(Round(([2010]),4),0) AS y2010
	, Coalesce(Round(([2011]),4),0) AS y2011
	, Coalesce(Round(([2012]),4),0) AS y2012
	, Coalesce(Round(([2013]),4),0) AS y2013
	, Coalesce(Round(([2014]),4),0) AS y2014
	, Coalesce(Round(([2015]),4),0) AS y2015
	, Coalesce(Round(([2016]),4),0) AS y2016
	, Coalesce(Round(([2017]),4),0) AS y2017
	, Coalesce(Round(([2018]),4),0) AS y2018
	, Coalesce(Round(([2019]),4),0) AS y2019
	, Coalesce(Round(([2020]),4),0) AS y2020
	, Coalesce(Round(([2021]),4),0) AS y2021
	, Coalesce(Round(([2022]),4),0) AS y2022
	, Coalesce(Round(([2023]),4),0) AS y2023
	, Coalesce(Round(([2024]),4),0) AS y2024
	, Coalesce(Round(([2025]),4),0) AS y2025
	, Coalesce(Round(([2026]),4),0) AS y2026
	, Coalesce(Round(([2027]),4),0) AS y2027
	, Coalesce(Round(([2028]),4),0) AS y2028
	, Coalesce(Round(([2029]),4),0) AS y2029
	, Coalesce(Round(([2030]),4),0) AS y2030
 
FROM
(SELECT FieldModelResult.PriceCase
	, FieldModelResult.MYear
	<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">,	AdjustedWI.Company, AdjustedWI.CompanyID</cfif>	
    <cfif ARGUMENTS.countryIncl IS "True">, Country.Country</cfif>
    <cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
    <cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
    <cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
    <cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
    <cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
    <cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
    <cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
    <cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
    <cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status AS CurrentStatus</cfif>
    <cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
    <cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
    <cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
    <cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
    <cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
    <cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
    <cfif ARGUMENTS.operatedIncl IS "True">, CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END AS Operated</cfif>
	<cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>
    
    , <cfif ARGUMENTS.ProductionTypeSelector IS "Net Boe">ROUND(COALESCE(SUM(FieldModelResult.NetBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif>* AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Gas">ROUND(COALESCE(SUM(FieldModelResult.NetGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Oil">ROUND(COALESCE(SUM(FieldModelResult.NetOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Boe">ROUND(COALESCE(SUM(FieldModelResult.GrossBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Gas">ROUND(COALESCE(SUM(FieldModelResult.GrossGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Oil">ROUND(COALESCE(SUM(FieldModelResult.GrossOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
</cfif>
 
FROM Field 
	INNER JOIN FieldModelResult ON Field.FieldID = FieldModelResult.FieldID 
	INNER JOIN AdjustedWI ON FieldModelResult.FieldID = AdjustedWI.FieldID AND FieldModelResult.MYear = AdjustedWI.MYear
    INNER JOIN Country ON Field.CountryID = Country.CountryID 
	INNER JOIN FieldDetail ON Field.FieldID = FieldDetail.FieldID
 
WHERE
0=0
<cfif ARGUMENTS.Company1 IS NOT "">AND (AdjustedWI.Company IN (<cfqueryparam value="#ARGUMENTS.Company1#" cfsqltype="cf_sql_varchar" list="yes" separator="|">))</cfif>
	
<cfif ARGUMENTS.Country1 IS NOT "">AND Country.Country IN (<cfqueryparam value="#ARGUMENTS.Country1#" cfsqltype="cf_sql_varchar" list="yes" separator="|">)</cfif>
 
<cfif ARGUMENTS.Region1 IS NOT "">AND FieldDetail.Region IN (<cfqueryparam value="#ARGUMENTS.Region1#" cfsqltype="cf_sql_varchar" list="yes" separator="|">)</cfif>
 
<cfif ARGUMENTS.Basin1 IS NOT "">AND FieldDetail.Basin IN (<cfqueryparam value="#ARGUMENTS.Basin1#" cfsqltype="cf_sql_varchar" list="yes" separator="|">)</cfif>
 
<cfif ARGUMENTS.Field1 IS NOT "">AND Field.Field IN (<cfqueryparam value="#ARGUMENTS.Field1#" cfsqltype="cf_sql_varchar" list="yes" separator="|">)</cfif>
 
<cfif NOT isDefined('ARGUMENTS.EquityIncl')>AND AdjustedWI.EquitySource = 1</cfif>
 
<cfif isDefined('ARGUMENTS.StatusSelector')> AND FieldModelResult.Status IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.StatusSelector#" list="yes" separator="|">)</cfif>
 
AND (FieldModelResult.PriceCase = <cfqueryparam value="#ARGUMENTS.PriceCaseSelector#" cfsqltype="cf_sql_varchar">)
 
<cfif isDefined('ARGUMENTS.waterCatSelector')>AND FieldDetail.WaterCatID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.waterCatSelector#" list="yes" separator="|">)</cfif>
 
<cfif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS NOT "">	AND (FieldDetail.FieldWaterDepthFt BETWEEN <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_varchar"> AND <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_varchar">)
<cfelseif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS "">	AND (FieldDetail.FieldWaterDepthFT >= <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_varchar">)
<cfelseif ARGUMENTS.waterDepthLow IS "" AND ARGUMENTS.waterDepthHigh IS NOT ""> AND (FieldDetail.FieldWaterDepthFt <= <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_varchar">)
</cfif>
 
<cfif isDefined('ARGUMENTS.APICatSelector')>AND FieldDetail.APICatID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.APICatSelector#" list="yes" separator="|">)</cfif>
 
<cfif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS NOT "">	AND (FieldDetail.APIGravity BETWEEN <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_varchar"> AND <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_varchar">)
<cfelseif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS "">	AND (FieldDetail.APIGravity >= <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_varchar">)
<cfelseif ARGUMENTS.APIGravityLow IS "" AND ARGUMENTS.APIGravityHigh IS NOT ""> AND (FieldDetail.APIGravity <= <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_varchar">)
</cfif>
 
<cfif isDefined('ARGUMENTS.ProjectCertaintySelector')>AND FieldDetail.ProjectCertaintyID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.ProjectCertaintySelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.SourceRockSelector')>AND FieldDetail.SourceRockID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.SourceRockSelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.ProductionSystemSelector')>AND FieldDetail.ProductionSystemID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.ProductionSystemSelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.GasQualitySelector')>AND FieldDetail.GasQualityID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.GasQualitySelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.HarshConditionSelector')>AND FieldDetail.HarshConditionID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.HarshConditionSelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.ProcessingSelector')>AND FieldDetail.ProcessingID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.ProcessingSelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.RecoveryCategorySelector')>AND FieldDetail.RecoveryCategoryID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.RecoveryCategorySelector#" list="yes" separator="|">)</cfif>
 
<cfif isDefined('ARGUMENTS.OperatedCategorySelector')>
<cfif listLen(ARGUMENTS.OperatedCategorySelector) EQ 3>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) LIKE '%')
</cfif>
<cfif listLen(ARGUMENTS.OperatedCategorySelector) EQ 2>		
<cfif listContainsNoCase(ARGUMENTS.OperatedCategorySelector,1) AND listContainsNoCase(ARGUMENTS.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(ARGUMENTS.OperatedCategorySelector,1) AND listContainsNoCase(ARGUMENTS.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Unknown')
<cfelseif listContainsNoCase(ARGUMENTS.OperatedCategorySelector,2) AND listContainsNoCase(ARGUMENTS.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Non-Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>																																																									
<cfif listLen(ARGUMENTS.OperatedCategorySelector) EQ 1>
<cfif listContainsNoCase(ARGUMENTS.OperatedCategorySelector,1)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Operated')
<cfelseif listContainsNoCase(ARGUMENTS.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(ARGUMENTS.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
																			WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
																			ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>
</cfif>
 
<cfif isDefined('ARGUMENTS.OECDCategorySelector')>AND FieldDetail.OECDCatID IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.OECDCategorySelector#" list="yes" separator="|">)</cfif>
 
 AND (FieldModelResult.MYear BETWEEN <cfqueryparam value="#ARGUMENTS.minYear#" cfsqltype="cf_sql_varchar"> AND <cfqueryparam value="#ARGUMENTS.maxYear#" cfsqltype="cf_sql_varchar">)
 
GROUP BY FieldModelResult.PriceCase
	, FieldModelResult.MYear
    <cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, AdjustedWI.CompanyID</cfif>	
   <cfif ARGUMENTS.countryIncl IS NOT "">, Country.Country</cfif>
   <cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
    <cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
    <cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
    <cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
    <cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
    <cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
    <cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
    <cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
    <cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status</cfif>
    <cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
    <cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
    <cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
    <cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
    <cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
    <cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
    <cfif ARGUMENTS.operatedIncl IS "True">, FieldDetail.Operator</cfif>
    <cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>) q1
PIVOT
(SUM(ProductionData) FOR q1.MYear IN
([1995],[1996],[1997],[1998],[1999],[2000],[2001],[2002],[2003],[2004],[2005],[2006],[2007],[2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020],[2021],[2022],[2023],[2024],[2025],[2026],[2027],[2028],[2029],[2030])) AS pvt
            
            <cfif gridsortcolumn neq ''>
        order by #gridsortcolumn# #gridsortdirection#
        </cfif>
			
</cfquery>
		
		
			
        <cfreturn queryconvertforgrid(Production,page,pagesize)/>
 
        
        
	</cffunction>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:

Select all Open in new window

by: av8or16Posted on 2009-10-20 at 11:05:09ID: 25616784

Correction:

Apparently the string is too long for Internet Explorer. It has a maximum of 2083 characters and my full url is 2119, so I will have to trim the names of my arguments.

However, it still doesn't change the error I specified in my previous post.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

For individual users
Instant access to solutions
Ask your tech questions
Start your 30-day Free Trial

Business Accounts

Perfect for organizations
Multiple users
Save over 36%
Create a Business Account

Answer for Membership

Earn free access
Showcase your knowledge
No credit card required
Sign Up to Answer

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...

Question

How do I use cfgrid with multiple additional arguments?

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Coldfusion

Binding

CFGRID

Cold Fusion Markup Language

ColdFusion Application Server

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press