Re: stored procedures and mysql

thanks greg, yes my hair is now growing back as we speak :) and unfortunately for our company i am the DBA :) In fact me and my business partner are the DBA's, programmers, designers, marketers, salesman etc.. but thanks to all you guys on this site we are are getting better at other things, o

Re: stored procedures and mysql

Richard, Glad to be of help. I hope that now you will have a great weekend, happy holidays, etc. (and that your hair will grow back :-) And more than that, I hope that with Scorpio the MySQL drivers bundled with CF will be upgraded. (Anyone from the CF team at Adobe lurking here on this list ?

Re: stored procedures and mysql

hi greg, you are a diamond :) I changed the driver over to the connector j 5.0 and added a new datasource not with mysql connection but with 'other' and set the configuration manually. I tried it and couldnt believe that it is now working. It does make alot of sense now that we know what it is.

Re: stored procedures and mysql

Richard, Although ColdFusion ships with MySQL database drivers, my sense is that these bundled drivers may not support Stored Procs. (Just guessing.) When I go into the ColdFusion Administrator, on the "Data Sources" page, the "Driver" dropdown for "Add New Data Source" has for MySQL "MySQL (3.x

Re: stored procedures and mysql

hi greg, just noticed that you said you were using a mysql-connector-java-3.1.12. i dont know if it makes any difference but i am using dreamweaver and have setup a mysql connection through it. Queries work fine but not the stored procedures. Do you think it may have something to do with the dr

Re: stored procedures and mysql

hi greg thanks for your reply. I thought that may be it for a minute but yes it is ticked - all of the allowed sql statements are ticked Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-t

Re: stored procedures and mysql

Richard, Just to confirm background stuff ... Is the following enabled: In ColdFusion Administrator --> Data Sources --> {select data source in question} --> Advanced Settings --> Allowed SQL --> Stored Procedures I am running stored procs with no problem with MySQL 5.0.19 with ColdFusion 7.0.2

stored procedures and mysql

Hi i posted a problem a while ago as i couldnt get stored procedures stored in mysql to work, it keeps coming up with a java.lang null pointer error. previous thread: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365 i was wondering if any using mysql and cfstoredproc could p