Unfortunately there are still some cases where our old, old wiki system gives more clues than our new docs. Sometimes I use the awesome Internet Archive to revisit them. http://web.archive.org/web/20110828071445/http://wiki.openbluedragon.org/wiki/index.php/CFPROCPARAM It seems OpenBD is very particular about what values you use for cfsqltype depending on which DB you use. Are you sure you're using a supported cfsqltype for mysql? OR (which I just figured out by trying to answer my last question) are you using cfprocparam or *cfqueryparam* within your cfstoredproc? It appears you can and are supposed to use cfqueryparam for cfstored proc: http://openbd.org/manual/?/tag/CFQUERYPARAM Hmm..I bet that's it.
Hope that helps. Aaron J. White On Friday, March 28, 2014 11:59:46 AM UTC-5, 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
