I found another way to do this

<cfquery datasource="#DsDB#" username="#UserDB#" password="#PassDB#"
name="result_OBTIENE_REFADUANA">
SELECT *
from "OBTIENE_REFADUANA"('0080','1','2000000999','3320','43','0','PE'
,'PE999','FT','1','2')

</cfquery>

Works fine.

thanks anyway.

Plutarco

--- In Firebird-Java@yahoogroups.com, "Plutarco"
<plutarco_gonzalez@...> wrote:

>
> Hi ...
>
> I have a firebird Store Procedure named "OBTIENE_REFADUANA".
> 15 rows with IBExpert result, but only 1 row with Coldfusion
>
> IbExpert and coldfusion has same input parameters.
> this is code:
>
> = = = = = = = = = = = = = = =
> <cfset sp = "OBTIENE_REFADUANA">
> <cfset sp_ip_cvecte = "0080">
> <cfset sp_ip_id_ejini = "1">
> <cfset sp_ip_id_ejfin = "2000000999">
> <cfset sp_ip_patente = "3320">
> <cfset sp_ip_aduana = "43">
> <cfset sp_ip_seccion = "0">
> <cfset sp_ip_cvesta1 = "PE">
> <cfset sp_ip_cvesta2 = "PE999">
> <cfset sp_ip_cvesta3 = "FT">
> <cfset sp_ip_tipoop1 = "1">
> <cfset sp_ip_tipoop2 = "2">
>
> <cfstoredproc procedure="#sp#" datasource="#DsDB#">
>
> <cfprocparam value="#sp_ip_cvecte#"
> type="in" dbvarname="cvecte"
> cfsqltype="cf_sql_varchar">
> <cfprocparam value="#sp_ip_id_ejini#"
> type="in" dbvarname="id_ejini"
> cfsqltype="cf_sql_numeric" null="no">
> <cfprocparam value="#sp_ip_id_ejfin#"
> type="in" dbvarname="id_ejfin"
> cfsqltype="cf_sql_numeric" null="no">
> <cfprocparam value="#sp_ip_patente#"
> type="in" dbvarname="patente"
> cfsqltype="cf_sql_varchar" null="no">
> <cfprocparam value="#sp_ip_aduana#"
> type="in" dbvarname="aduana"
> cfsqltype="cf_sql_varchar" null="no">
> <cfprocparam value="#sp_ip_seccion#"
> type="in" dbvarname="seccion"
> cfsqltype="cf_sql_char" null="no">
> <cfprocparam value="#sp_ip_cvesta1#"
> type="in" dbvarname="cvesta1"
> cfsqltype="cf_sql_varchar" null="no">
> <cfprocparam value="#sp_ip_cvesta2#"
> type="in" dbvarname="cvesta2"
> cfsqltype="cf_sql_varchar" null="no">
> <cfprocparam value="#sp_ip_cvesta3#"
> type="in" dbvarname="cvesta3"
> cfsqltype="cf_sql_varchar" null="no">
> <cfprocparam value="#sp_ip_tipoop1#"
> type="in" dbvarname="tipoop1"
> cfsqltype="cf_sql_numeric" null="no">
> <cfprocparam value="#sp_ip_tipoop2#"
> type="in" dbvarname="tipoop2"
> cfsqltype="cf_sql_integer" null="no">
> <cfprocresult name = "Result_OBTIENE_REFADUANA">
>
> </cfstoredproc>
>
> <cfdump var="#Result_OBTIENE_REFADUANA#">
>
> = = = = = = = = = = = = = =
>
>
> Why only row?
>
> Anyone can help me
>
> Many Thanks
>
> Plutarco Gonzalez
>