Re: [OpenBD] or ?

[Alan Holden]

Here's a simple SP I created in an Amazon MySQL RDS (an existing datasource for an existing OpenBD app): DELIMITER $$ USE `myDatabase`$$ CREATE PROCEDURE `myDatabase`.`testCFSTORPROC` (OUT em CHAR(80)) BEGIN     SELECT useremail INTO em     FROM `myDatabase`.`user` WHERE iduser = 1; END$$ After I compiled that, I ran this CFML in my OpenBD desktop version 3.0; Build=2013-03-04 04:03:30 GMT <cfstoredproc datasource="myDatasource" procedure="testCFSTORPROC" result="testResult">     <cfprocparam type="out" cfsqltype="CF_SQL_VARCHAR" variable="theEmail" /> </cfstoredproc> <cfdump var="#testResult#" /> <cfdump var="#theEmail#" /> Both the testResult structure (with the execution time) and theEmail variable were displayed out without issue. So OpenBD's cfstoredproc seems to be executing - under this simple test at least! HTH, Al On 3/28/2014 4:51 PM, Alan Holden wrote: From a search; it appears as though "cfSTOREDPROC" is present in the OpenBD source, which would lead me to think that it's supposed to be supported: http://websvn.openbd.org/websvn/filedetails.php?repname=OpenBD&path=%2Ftrunk%2Fsrc%2Fcom%2Fnaryx%2Ftagfusion%2Fcfm%2Fsql%2FcfSTOREDPROC.java&rev=2374&peg=105 Perhaps you can post stripped-down versions of your SP and/or calling CFML - to use as a test case? Al On 3/28/2014 9:59 AM, Douglas McGregor wrote: Hi everyone, Been trying to use <cfstoredproc> with MySQL and not having any luck.  I keep getting the error "FUNCTION personalwebsitecoldfusion.AddUser does not exist", but I can guarantee you that it does exist!  It gets a bit better with <cfquery> since it actually returns parameter errors, which I was just doing as a test.  I'd prefer to use <cfstoredproc>, but there's no documentation about it in the official OpenBD manual.  Just wondering if <cfstoredproc> is actually supported in OpenBD, or should I just make life easier and use <cfquery>?  Thanks Douglas -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.