Professional Web Applications Themes

MySQL 5 + MX7 stored proc problem - Coldfusion Database Access

I had the usual issues with driver incompatibility: "null null" error and then, after installing connector/j 3.0.17 I got "Callable statments not supported". I could not find the elusive 3.2 driver on the mysql site, so we installed the 5.0 driver (beta). Now, I'm not getting any results returned from my stored proc. The error is: -- Element RECORDCOUNT is undefined in QSIMPLEPROC I also tried pulling the statuscode and got: -- Element STATUSCODE is undefined in CFSTOREDPROC The debugging looks correct. it appears that the stored proc is running (liberties taken with formatting to make it readable): simpleproc (Datasource=test, ...

  1. #1

    Default MySQL 5 + MX7 stored proc problem

    I had the usual issues with driver incompatibility: "null null" error and then,
    after installing connector/j 3.0.17 I got "Callable statments not supported".
    I could not find the elusive 3.2 driver on the mysql site, so we installed the
    5.0 driver (beta).

    Now, I'm not getting any results returned from my stored proc. The error is:

    -- Element RECORDCOUNT is undefined in QSIMPLEPROC

    I also tried pulling the statuscode and got:

    -- Element STATUSCODE is undefined in CFSTOREDPROC

    The debugging looks correct. it appears that the stored proc is running
    (liberties taken with formatting to make it readable):

    simpleproc (Datasource=test, Time=0ms) in //_qry_financialAggregate.cfm
    10:36:38.038

    parameters
    ----------------
    type = OUT
    CFSQLType = cf_sql_integer
    value =
    variable = oID = oID
    dbVarName


    resultsets
    ----------------
    name = qSimpleproc
    resultset = 1

    But...nothing is returned. What gives?

    jperkins99 Guest

  2. #2

    Default Re: MySQL 5 + MX7 stored proc problem

    Nevermind...the problem was that I needed to "SELECT" the variables at the end of the stored proc in order to return the values to coldfusion.
    jperkins99 Guest

Similar Threads

  1. CF5 to MX7 Problem: Sybase Stored Proc's dont work right
    By DaveF67 in forum Coldfusion Database Access
    Replies: 3
    Last Post: September 28th, 06:37 PM
  2. cfc and stored proc
    By mcoop in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: April 13th, 05:09 PM
  3. Stored Proc problem
    By mitaka in forum ASP Database
    Replies: 1
    Last Post: May 3rd, 05:11 PM
  4. Stored proc problem on 9.30.UC1
    By Weaver, Bill in forum Informix
    Replies: 1
    Last Post: July 9th, 02:35 PM
  5. stored proc and tcp/ip
    By Helmut Wöss in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: June 30th, 08:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139