|
|
I got it. I will post the code. Thanks for your help Ian. I can help anytime if
you need any Flash help, I'm great at that.
<!-- shippers contracts -->
<cffunction name="getShippersDetails" access="remote" returnType="query">
<cfargument name="shippersList" type="string" required="yes">
<cfargument name="shipperId" type="numeric" required="yes">
<cfquery name="getShippersDetailsQuery" datasource="rexmap"
username="****" password="****">
SELECT COUNT(DISTINCT(tblcvp.cvpContract)) AS Contracts,
tblcvp.cvpPplFERC
FROM tblcvp
WHERE cvpPplFERC IN (<cfqueryParam value="#arguments.shippersList#"
list="yes" cfSQLtype="cf_sql_integer">)
AND cvpShprDUNS = <cfqueryparam value="#arguments.shipperId#"
cfsqltype="cf_sql_integer">
GROUP BY tblcvp.cvpPplFERC
</cfquery>
<cfreturn getShippersDetailsQuery>
</cffunction>
<!-- -->
<!-- -->
<!-- -->
|
|