Subject | Store Procedure with Cold Fusion MX |
---|---|
Author | Plutarco |
Post date | 2007-04-17T00:30:50Z |
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
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