macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Array argument array return

Subject: Re: Array argument array return
From: "C-Rock"
Date: Tue, 4 Mar 2008 20:53:24 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion

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>
 <!-- -->
 <!-- -->
 <!-- -->


<Prev in Thread] Current Thread [Next in Thread>