CF syntax for a MySql stored procedure

http://forums.hostmysite.com/about2913.html

call getGroups()

using the DSN-less code

classLoader = createObject("java", "java.lang.Class"); classLoader.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dm = createObject("java","java.sql.DriverManager"); con = dm.getConnection("jdbc:odbc:DRIVER={MySQL ODBC 3.51 Driver}; SERVER=[my server IP address]; PORT=3306; DATABASE=mysqldb; USER=testuser; PASSWORD=password; OPTION=3;"); st = con.createStatement(); rs = st.ExecuteQuery("call mysqldb.getGroups();"); q = createObject("java", "coldfusion.sql.QueryTable").init(rs);