Hi all.
I've been having a kind of frustrating experience trying to port an
app over from BD7 .NET and SQL Server 2K5 to OpenBD and MySQL.
Amongst the more vexing issues is an apparent issue with calling a
MySQL stored procedure in my CF app with CFSTOREDPROC.
I have a block of code that looks like this:
<cfstoredproc procedure="g_states"
datasource="#application.datasource#" returncode="Yes">
<cfprocresult name="getStates">
</cfstoredproc>
Normal call to a simply stored procedure. This procedure just returns
a dataset comprised of the state name and state abbreviation.
However, that line of code will produce this error every time:
Error occurred while processing element (CFSTOREDPROC) on line 55
column 2 in template file
However, if I replace that code with this code:
<cfquery name="getStates" datasource="#application.datasource#">
CALL g_states();
</cfquery>
...it works fine. Same stored proc, different call. Now, this isn't
that big a problem but it's pretty damned annoying and it means I'll
need to go all over my code and replace all the cfstoredproc calls
with the cfquery versions.
Any idea why this would be doing this? If there is an idea, is there
a fix? I've got a list of other issues to attend to so an easy fix or
workaround would help me cross this issue off the roll.
Any insights into this issue would be greatly appreciated. Thanks in
advance.
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
