Forums
This topic is locked
MYSQL STORED PROCEDURES COLDFUSION PROBLEM
Posted 18 Mar 2008 12:43:11
1
has voted
18 Mar 2008 12:43:11 misha antsibor posted:
MYSQL 5 HELP!!can't call any sql stored procedures from CF 8.
Have tried both variants CFSTOREDPROC and CFQUERY:
<cfstoredproc procedure="iu_style" datasource="#application.ds#" returncode="yes">
<cfprocparam type="inout" cfsqltype="cf_sql_integer" dbvarname="@op_nstyleid" value="#form.styleid#" variable="styleid_" null="no" >
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@p_style" value="#form.style#" null="no">
</cfstoredproc>
error:{
FUNCTION MYDB.iu_style does not exist
}
<cfquery name="q_get" datasource="#application.ds#">
set @e=1;
call iu_style(@e, '#form.style#', 1);
</cfquery>
{ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; call iu_style(e, 1 , 1)' at line 1}
Althouth the statement runs succesfully in MYSQL browser.