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.

Reply to this topic