Structured Procedures called from MySQL 5

Replies to This Discussion

Permalink Reply by Brian Brant on July 1, 2008 at 12:48pm

Rick,

Are you using a cfprocresult nested inside your ?

I'm using CF with MySQL 5 as well. Here's an example of a call to/from a stored proc.



cfstoredproc
procedure="spMyProcedure"
datasource="#application.dsn#"
returncode="no"

cfprocparam dbvarname="varMyVar" value="#form.txtTextName#" cfsqltype="cf_sql_varchar" type="in"

cfprocresult name="qryMyQueryResults"


The stored proc in MySQL looks like this:

CREATE DEFINER=`root`@`%` PROCEDURE `spMyProcedure`(IN varMyVar VARCHAR(45))
BEGIN
SELECT COLUMN1,
COLUMN2,
COLUMN3
FROM tblMyTable
WHERE COLUMN1 = varMyVar;
END

You could then use qryMyQueryResults as a qualifier in instances such as qryMyQueryResults.RecordCount.

Hope that helps.
Brian

▶ Reply to This

Permalink Reply by Rick Turner on July 3, 2008 at 6:03pm

Hi, thnks for info, sorted it out wonderful, thanks again

▶ Reply to This