mysql stored procedure does not show up

[adpk77]

In dreamweaver when i select stored procedure, the one i created does not show up in the list. I am using mysql database and using it to develop coldfusion application. my mysql database has 1 stored procedure that was created using navicat GUI.

why is it not showing up in the drop down menu?

 

[adpk77]

Actually I am not very familiar with stored procedures. I only require it to navigate through indivudual recordsets on the detail page of a master-detail setup. The detail page will display each record in detail from the database.

I was going through a certain article regarding this and it uses stored procedures.

However i did manage to hand code it within coldfusion but it still shows error.
Below is the code in detail1.cfm

<CFSTOREDPROC procedure="nextandprevious" datasource="976evil_db">
<CFPROCPARAM type="IN" dbvarname="@id" value="#url.recordID#" cfsqltype="CF_SQL_INTEGER">
<CFPROCPARAM type="OUT" dbvarname="@prev" variable="out_prev" cfsqltype="CF_SQL_INTEGER">
<CFPROCPARAM type="OUT" dbvarname="@next" variable="out_next" cfsqltype="CF_SQL_INTEGER">
</CFSTOREDPROC>

On running the page, when i click any record on master page, I get the following error.
Error Executing Database Query.
Result consisted of more than one row

Exceptions

21:19:04.004 - Database Exception - in C:\CFusionMX\

http://wwwroot\Previous_and_Next_Links_for_Details_Page_Stored_Procedure\detail1.cfm

: line 4

Error Executing Database Query.

Code for the previous link on page is shown below.
<a href="detail1.cfm?<cfoutput>#Recordset1.blog_item_id#</cfoutput>=<cfoutput>#out_prev#</cfoutput>">PREVIOUS </a>

Where am i going wrong?

 

[traingamer]

If you are certain that the stored procedure exists in MySQL (and actually works), then you are probably better off asking this question in the Cold Fusion forum.