Ask a Question related to Coldfusion Database Access, Design and Development.
-
Geektime #1
mySQL Stored Prcocedures won't work
I've been spending the better part of the morning pulling my hair out trying to
get CF to use stored procedures from MySQL. Here is what I am running:
MySQL version 5.0.18
CFMX7 version 7,0,1,116466
mysql-connector-java-3.1.12-bin.jar
I have two stored procedures for testing purposes, one requiring two
parameters, one with no parameters. Both work from the mysql command line.
When I attempt to execute the stored procedure requiring parameters, here is
what I get:
Error Executing Database Query.
Parameter index out of range (3 > number of parameters, which is 2).
The debug information is "{ (param 1) = call spTest2( (param 2) , (param 3) )}"
When I attempt to execute the stored procedure without any parameters, here is
what I get:
Error Executing Database Query.
Unknown column 'spTest' in 'field list'
The debug information is "{ (param 1) = call spTest}"
The first thing I noticed was that the stored procedure without any parameters
should say spTest(), but does not. Is this a problem with the JDBC connector?
Thanks,
Alex
Geektime Guest
-
Flash swf Ads stored in Mysql database
Hi Everyone, I am using Dreamweavers' Development toolkit and can upload images such as JPG and GIF files to my server and add their file name to... -
converting a MySQL 4.1 subquery to something that'll work with MySQL 4.0
Say I have the following SQL query: UPDATE phpbb_users SET user_nthpost = ( SELECT post_time FROM phpbb_posts WHERE phpbb_users.user_id =... -
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... -
Calling stored procedure from MysQL 5.0
I am trying to call stored procedures using <cfquery> in Coldfusion MX 7.0, but I am getting this error: Error Executing Database Query. General... -
Does MySQL have a Stored Procedure equivalent?
I've only used ASP and MS SQL Server before but I want to learn PHP and MySQL. Does MySQL have an equivalent of Microsoft's Stored Procedures (i.e.... -
Geektime #2
Re: mySQL Stored Prcocedures won't work
Forgot to include the CF Code:
<cfstoredproc procedure="spTest2" datasource="xxxxx" returncode="Yes">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="testval1"
value="#FORM.testval1#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="testval2"
value="#FORM.testval2#">
<cfprocresult name="Test" resultset="1">
</cfstoredproc>
<cfstoredproc procedure="spTest" datasource="xxxxx" returncode="Yes">
<cfprocresult name="Test" resultset="1">
</cfstoredproc>
Geektime Guest



Reply With Quote

